KB-1240 Date/time displays an incorrect value for one or more users

Symptoms

A date or datetime does not reflect the expected value for the user or the time zone.

When setting the value for a date like so:

pv!myDate = date(2016, 08, 17)

The displayed date is sometimes one day prior:

"08/16/2016"

Cause

The variance seen is the GMT offset for the user or Appian-wide time preference being applied. The date set in the example above is equivalent to:

"08/17/2016 00:00:00 GMT"

The date is set in GMT and, by default, does not contain the GMT offset for the User.

Action

  1. When setting a date value, wrap in the GMT function like so:
    gmt(date(2016, 08, 17))
  2. Ensure the "Primary Time Zone" setting in Appian Designer > System > Internationalization Settings is correct and also check if the system overrides user preferences.

Affected Versions

This article applies to all versions of Appian.

Last Reviewed: March 2017

Related
Recommended