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

Topic Labels: Dates & Timezones
1152 4
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

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

Captura de Pantalla 2022-04-25 a la(s) 21.36.17

Captura de Pantalla 2022-04-25 a la(s) 21.37.35

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

Captura de Pantalla 2022-04-25 a la(s) 21.34.32

thanks in advance

4 Replies 4

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.

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.

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