KB-1363 Today() returns one day prior when timezone is set to AST (Australia/Darwin)

Symptoms

When a user's timezone is set to Australia Standard Time (Australia/Darwin) the date returned by today() is one day prior

For example, if today's date is 5-MAY-2017, today() would return 4-MAY-2017.

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

As a workaround for this issue, please use the following expression in place of today() :

todate(datetext(now(),"MM/dd/yyyy"))

This article applies to all versions of Appian.

Last Reviewed: May 2017