Hi, I noticed something very strange with now() function. todate(now(

senthilar over 11 years ago

Hi,

I noticed something very strange with now() function. todate(now()) returns 2/21/2014 though today is only 2/20/2014. When I just put now(), it returns value correctly 2/20/2014 5:14 PM PST

Our calendar is set to GMT - 8 hrs (PST) and our working hours is set to 9 AM to 5 PM.

Why now() is behaving this way?

...

Discussion posts and replies are publicly visible

0 Eduardo Fuentes
Appian Employee
over 11 years ago

This is the right syntax if using todate()

=todate(local(now()))

to adjust the fact that the todate() expects a GMT date
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 senthilar over 11 years ago

Thank you Eduardo! This worked and the issue is resolved!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 moritzw over 11 years ago

Wouldn't using today() be easier?!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel