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
6 replies
Subscribers
7 subscribers
Views
4169 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
AI and Rules
Hi, datetext(todate(tostring(now())),"MMM, dd yyyy") instead
Rajeev Hugar
Certified Senior Developer
over 7 years ago
Hi,
datetext(todate(tostring(now())),"MMM, dd yyyy") instead of giving today's date, its returning previous day's date.
How to resolve this issue?
OriginalPostID-216546
OriginalPostID-216546
Discussion posts and replies are publicly visible
0
Colton Beck
over 7 years ago
The following should work better for you:
text(todate(tostring(now())),"MMM, dd yyyy")
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Colton Beck
over 7 years ago
And the following is less expensive:
text(today(),"MMM, dd yyyy")
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Alex
over 7 years ago
It would appear that there is something wrong with the datetext function. The solution coltonb suggested is your best bet. If you simply must use datetext, change you can do datetext(today()+1,"MMM, dd yyyy")
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Rajeev Hugar
Certified Senior Developer
over 7 years ago
Thanks Coltonb, text() works for me.
Just curious is there any logical explanation or its a bug that
text(todate("6/7/2016 9:05 AM"),"MMM, dd yyyy") ==> Jun, 07 2016
datetext(todate("6/7/2016 9:05 AM"),"MMM, dd yyyy") ==> Jun, 06 2016
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Colton Beck
over 7 years ago
This should provide you some insight:
forum.appian.com/.../e-118668
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Rajeev Hugar
Certified Senior Developer
over 7 years ago
Thanks @Alexanderp for work around and @Coltonb for the link
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel