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

[Sebastian_Castro]

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

[Adam_C]

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?

[Sebastian_Castro]

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

[kuovonne]

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.

[Adam_C]

@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!