Can someone explain why datetext() is returning 2022-11-30 given the input of the date 12/1/2022. I came across this thread which states datetext() is no longer supported however it appears within the latest (24.4) All Functions list within Appian. community.appian.com/.../issue-with-using-datetext-function-in-appian-portals
Discussion posts and replies are publicly visible
haseeb.shuaib said:datetext() is returning 2022-11-30 given the input of the date 12/1/2022
As noted in Mathieu's link, wrap the date in gmt(). dateText() is formatting the date value stored in the variable which is "12/1 at 12:00 AM GMT", which in any further-west timezone will resolve as sometime on the evening of 11/30.