Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

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

Topic Labels: Dates & Timezones
307 4
cancel
Showing results for 
Search instead for 
Did you mean: 

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

when…
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!