KB-1363 Today() returns one day prior when locale is set to particular time zones

Symptoms

When a user's locale is set to some particular time zones, such as Australia Standard Time (Australia/Darwin) or Japan Standard Time (Asia/Tokyo), the date returned by today() is one day prior to expected.

For example, if today's date is 17-JANUARY-2024, today() would return 16-JANUARY-2024.

Cause

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

Workaround

Use either of the following expressions in place of today():

  • todate(local(now()))
  • date(useryear(now()), usermonth(now()), userday(now()))

Affected Versions

This article applies to all versions of Appian.

Last Reviewed: January 2024

Related
Recommended