Working with Date fields in imports, field default scripts, business rules and all other places where you can use Server based Javascript is often seen as complex.

This is caused by all kinds of automatic conventions taking place.

  • All DateTime fields are internally stored in SNC in UTC format.
  • All DateTime fields are displayed in User format.
  • All DateTime fields entered using a User account are converted from user format and TZ to UTC format.
  • All DateTime fields filled with a string from Javascript are stored directly as UTC format.

Daylight Saving Periods make it complex to compute an exact LocalTime based on the UTC format.

To make Imports reproducible it’s advised to know under which credentials an Import or Scheduled job runs.
The fields ‘Run As’ and ‘Run as TZ’ are out-of-the-box not displayed in the Scheduled Jobs.

Continue reading…»