Skip to main content

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

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?

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!

Reply


Terms & Conditions