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 :-)
I meant DATEVALUE and not DATAVALUE :-)
Please help me Brendan
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.
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.
.
