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
Today()
returns a UTC date (with no time value). As [DateTime field] is of the type date-time, we convertToday()
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 theNow()
function instead.