Now() vs Today()

I discovered that I had to use Now() instead of Today(). Just sharing this here as I don’t see yet search results for Now() here in discourse :slight_smile:

Today() returns a UTC date (with no time value). As [DateTime field] is of the type date-time, we convert Today() to a date-time value, setting the time as the beginning of the day in UTC. You will see 02:00 in the UI because you’re in the GMT+2 timezone. In this particular case, it might be better to use the Now() function instead.

https://help.fibery.io/en/articles/5499837-timezones

2 Likes

I no longer see Now() as a function when I try to build a formula

Now() exists in Automations only, for Formula Now is not very clear.