Now() vs Today()

Get Help
1

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
2

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

3

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

4

I’m quite used to this nuance in many platforms. I think the latest changes to date pickers makes a great case for why we need now vs today.
Example:
I needed to filter my tasks based on creation date which used to work by selecting today but now, I need to choose the date range.