Question

issue with converting date to string

Forum|Forum|4 years ago
March 30, 2022
12 replies
0 views

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

L

linp0001Author

sorry the datetext(today(), "YMMd") return "20220328", not "20200328"

mathieud0001

Date format should be "yyyyMMdd"

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

arockiaprincyv0003

today() function returns the current day in Greenwich Mean Time (GMT) so the result may differ from the current day in your local timezone.

gopalk2865

Participating Frequently

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.

L

linp0001Author

if you run just today(), you got the same date?

gopalk2865

Participating Frequently

yes, i am getting the same result .

mikes0011

Brainy

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()".

L

linp0001Author

Thanks Mike, it's working.

S

sairohitd054766

text(today(),"yyyyMMdd")
This returns the expected one.

L

linp0001Author

thank you.

Sign up

Login with SSO

Login to the community

Login with SSO