When a user timezone is GMT-1 and below, the function datetext() returns a day prior to the expected date.
For example, a user with Eastern Time(America/New_York) set as their timezone will see "2017/05/08" as a result of this expression:
datetext(date(2017, 05, 09), "yyyy/MM/dd")
This issue has been reported to the Appian product team. The reference number for this issue is AN-43209.
Wrap the date with the gmt() function:
datetext(gmt(date(2017, 05, 09)), "yyyy/MM/dd")
This article applies to all versions of Appian.
Last Reviewed: May 2017
© 2021 Appian. All rights reserved.