DISCO can parse multiple date and time formats into common date fields. We recommend mapping these fields to existing date fields so that you can benefit from the search, filter and sort functionality DISCO. The following fields are available for mapping in load file ingests and overlays:
- Createdate, Createtime
- LastModifiedDate, LastModifiedTime
- Senddate, Sendtime
- ReceivedDate, ReceivedTime
- LastAccessedDate, LastAccessedTime (Overlay Only)
- LastPrintedDate, LastPrintedTime (Overlay Only)
Accepted Date & Time Formats
|
Format |
Date and Time in one field (example) |
|
Month-Day-Year HH:MM:SS AM or PM |
09-17-2014 1:23:45 AM |
|
Month-Day-Year HH:MM:SS |
09/17/2014 13:23:45 |
|
Month Day, Year, HH:MM:SS CST |
Sept 17, 2014 1:23:45 CST |
|
Month Day, Year, HH:MM:SS AM or PM |
October 2, 2019 1:23:45 AM |
|
Mon Day Year Time+offset |
Mar 1 2020 1:23:45+00:00 |
Accepted Date Formats
|
Format |
Date Format Examples |
|
Month-Day-Year |
09-17-2014 |
|
Month/Day/Year |
09/17/2014 |
|
Mon Day, Year (month as a 3 letter abbreviation. Can be 3 or 4 letter acronym for Sept) |
Sept 17, 2014 |
|
Month Day, Year |
September 17, 2014 |
|
Mon Day Year (month as a 3 letter abbreviation. Can be 3 or 4 letter acronym for Sept) |
Sept 17 2014 |
|
Month Day Year |
September 17 2014 |
Accepted Time Formats
|
Format |
Time Formats Examples |
|
AM / PM (upper or lower case) Matter timezone used |
1:23:45 AM |
|
24-hour clock Matter timezone used |
13:23:45 |
|
24-hour clock CST timezone |
1:23:45 CST |
|
24-hour clock UTC timezone |
1:23:45+00:00 |