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!
"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.
Oh! so clever attemp, thaaaanks, but it is not working neither. CG is a date so this formula returns an ERROR
Oh! so clever attemp, thaaaanks, but it is not working neither. CG is a date so this formula returns an ERROR
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.