Grab DATAVALUE from Date Created field

Tagged: 

Viewing 3 reply threads
  • Author
    Posts
  • August 17, 2019 at 5:19 AM #36352

    Paolo
    Participant

    Dear Brendan, I need your help :-)

    I use the following formula to grab DATAVALUE from “Date” field:

    IF([Date Field]>DATEVALUE("01/09/2019"; "dd/MM/yyyy") ; [A];)

    It works fine, but I’m trying also to grab DATAVALUE from “Date Created” field with or without hours, minutes, seconds.
    I thought that the above formula worked too with “date created” field that doesn’t contain hour, but it doesn’t works. I tried also the following formula to grab DATAVALUE from “date created” field that contains hours without success:

    IF([Date Created Field]>DATEVALUE("01/09/2019 13:30:15"; "dd/MM/yyyy HH:mm:ss") ; [A];)

    Can you please let me know how can I grab DATAVALUE from “date Created” field (with or without hour)?

    Thanks for your time :-)

    August 17, 2019 at 10:59 AM #36356

    Paolo
    Participant

    I meant DATEVALUE and not DATAVALUE :-)
    Please help me Brendan

    August 17, 2019 at 11:31 AM #36357

    Paolo
    Participant

    The following formula works with Date field:

    IF([Date Field]>DATEVALUE("01/09/2019"; "dd/MM/yyyy") ; [A];)

    The following formula works with Date&Hour field:

    IF([DateHour Field]>DATEVALUE("01/09/2019 13:15:10"; "dd/MM/yyyy HH:mm:ss") ; [A];)

    But both doesn’t work with Date Created and Date Modified field.

    August 18, 2019 at 11:42 AM #36366

    Brendan
    Keymaster

    So this formula worked ok for me. But I simply edited the formula by putting spaces on either side of all the semi-colons. It worked properly when using the Date Created field in your form.

Viewing 3 reply threads

You must be logged in to reply to this topic.