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.
today()
This issue has been reported to the Appian Product team. The reference number for this issue is AN-41155.
Use either of the following expressions in place of today():
todate(local(now()))
date(useryear(now()), usermonth(now()), userday(now()))
This article applies to all versions of Appian.
Last Reviewed: January 2024