issue with converting date to string

Question

Hi there, 
 I need to use the date string in format "YMMd", for example, "20220329" for today. 
 I am using the datetext function: datetext(today(), "YMMd"), if today() function return "03/29/2022", then the datetext(today(), "YMMd") will return "20200328". what's the issue there? why I cant get "20220329"? what's the good way to archive it? 
 Thanks! 
 Lin

Mike Schmitt · Answer

FWIW I always seem to have better results using "text()" for these, rather than "datetext()". Also as Princy noted above already, you need to account for GMT conversion - I would suggest trying the same code but with "today()" wrapped in "local()".

Mathieu Drouin · Answer

Date format should be "yyyyMMdd" 
 Also be aware of this: community.appian.com/.../kb-1344-datetext-returns-one-day-before-expected-date

GopalK · Answer

Hi, I am using the same code which you are using and i am getting expected result, please see below. I would suggest you check your environment time zone.

issue with converting date to string

Top Replies