Export date and time formats

Because some export formats are intended for human consumption and others are intended for database usage, different methods provide date and time field information in different formats.

Excel

Date, Date-Time, and Time fields are all exported as their display values, displayed using a custom format instead of the system date format.

Duration fields, however, export as the value stored in the database, which is an integer value of seconds.

XML

All Date and Time fields export as the value stored in the database.

PDF

All Date and Time fields (including Duration) export as their display value.

CSV

All Date and Time fields export as the value stored in the database.