Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
3 replies
Subscribers
8 subscribers
Views
1339 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
Hi, I noticed something very strange with now() function. todate(now(
senthilar
over 10 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?
...
OriginalPostID-100716
OriginalPostID-100716
Discussion posts and replies are publicly visible
0
Eduardo Fuentes
Appian Employee
over 10 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 10 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 10 years ago
Wouldn't using today() be easier?!
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel