Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Aug 25, 2023 12:01 AM
Something sooooo wierd is happening to me that is driving me crazy
I am trying to compare a date with today. Easy task aparently. (anyway working on dates is never easy to me)
Look what is going on:
Two date fields created
Date 1 is TODAY
Date 2, the date of a free class at my school
Now i created two testing formulas
And testing 2. Just substituting Date 1 field by today()
So both formulas are supposed to give the same output, but....
OMG!!! no idea about what is happening! Any help please!
Solved! Go to Solution.
Aug 25, 2023 08:52 AM - edited Aug 25, 2023 08:55 AM
Airtable has a set of functions to handle dates (since it doesn't treat them as Excel would, as date-based numbers). In this case, you can use IS_BEFORE({Date of free class}, TODAY()).
https://support.airtable.com/docs/formula-field-reference#date-and-time-functions
Aug 25, 2023 04:35 AM - edited Aug 25, 2023 04:35 AM
"Date 2" seems to be recognized as a string.
DATETIME_PARSE({CG},"M/D/YYYY h:mma")
to parse it correctly would fix the problem.
Aug 25, 2023 05:11 AM
Oh! so clever attemp, thaaaanks, but it is not working neither. CG is a date so this formula returns an ERROR
Aug 25, 2023 08:52 AM - edited Aug 25, 2023 08:55 AM
Airtable has a set of functions to handle dates (since it doesn't treat them as Excel would, as date-based numbers). In this case, you can use IS_BEFORE({Date of free class}, TODAY()).
https://support.airtable.com/docs/formula-field-reference#date-and-time-functions