Treatment of date/time in Axiom Software

System-managed date/time values are stored as Coordinated Universal Time (UTC) in the Axiom Software database. When these values are displayed to users, they are converted to the user's local time. This includes date/time values such as:

Dates and times reported by Scheduler
CreatedDTM and ModifiedDTM values displayed in various locations
Dates and times in the audit log
Any other date/time values generated by Axiom Software

For example, if a Scheduler job is processed at 4:00 PM on a server that is located in the U.S. Eastern time zone, a user in the U.S. Pacific time zone will see the processing time as 1:00 PM.

NOTE: Due dates for workflow and process management are stored as dates, not date-time values. These values will be the same for all users.

Date/time values can also be stored in user-defined tables, in DateTime columns. Values in user-defined DateTime columns are stored in the database "as is". No conversion is performed on the data when it is saved, and no conversion is performed on the data when it is queried and displayed to users. The stored value will display as the same date/time value to all users.