date comparison bug? or just am I making any mistake?

[David_Alonso]

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!

[Sho]

"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.

[David_Alonso]

Oh! so clever attemp, thaaaanks, but it is not working neither. CG is a date so this formula returns an ERROR

[Andy_Lin1 · Accepted solution]

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