Formular doesn't read as true() when date match with today()

+3

Hi all,
I have this formula IF(date={today()},TRUE(),FALSE())

when…

As you can see the column today() = true() doesn’t mark as true() even though they are the same.

thanks in advance

+31

Hi @Sebastian_Castro, I can’t seem to replicate this, check out my attempt here in a readonly base: Base

Could you replicate this on a new base (so that there’s no private data on it) and share it so I could help you take a look at it?

Adam, Airtable Consultant - thetimesaving.company

+3

Hi @Sebastian_Castro, I can’t seem to replicate this, check out my attempt here in a readonly base: Base

Could you replicate this on a new base (so that there’s no private data on it) and share it so I could help you take a look at it?

Thnks @Adam_TheTimeSavingCo !
it´s read only for me. please be kind to let me update the base to check it.

+29

When working with dates, I recommend using date functions for comparison. In this case, I recommend using something like

IS_SAME({date}, TODAY(), 'day')

You may also have timezone issues.

+31

@Sebastian_Castro Yeap, I was thinking you’d duplicate the base into your own workspace, actually.

I’ve given you permissions for the base linked above, so you should be able to access the formulas now!

Adam, Airtable Consultant - thetimesaving.company

Sign up