Why is my time off by an hour with Now()?

7

I had this problem too, but it’s off by 9 hours since I’m in Sweden!

Like @mallika suggests I created a variable:
NowLocal() = Now() + Hours(9)

I also needed to change the Today() so that it was correct:
TodayLocal() = NowLocal().DateTimeTruncate("day")

4 Likes