Thank you for your feedback.
Form temporarily unavailable. Please try again or contact docfeedback@servicenow.com to submit your comments.

Export date and time formats

Log in to subscribe to topics and get notified when content changes.

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.

Note: If the date and time format is hh:mm:ss in the glide.sys.date_format setting in System Properties, and you export time values to Excel, they show in 24-hour military time format. To display the exported values in standard 12-hour am/pm time formats, select the 1:30PM time format in Format Cells > Time in Excel.
hh:mm:ss

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.

Feedback