KB-1344 Datetext() returns one day before expected date

Symptoms

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

Cause

This issue has been reported to the Appian product team. The reference number for this issue is AN-43209.

Action

Wrap the date with the gmt() function: 

datetext(gmt(date(2017, 05, 09)), "yyyy/MM/dd")

Affected Versions

This article applies to all versions of Appian.

Last Reviewed: May 2017