Date data and date & time data in a report column can be formatted using the following options:
|
Formatting Option |
Description |
|---|---|
|
Short Date |
Formats dates as MM/DD/YYYY. For example, March 12, 2018 is formatted as 3/12/2018. No time indicator is displayed. |
|
Long Date |
Formats dates as Weekday, Month Date, Year. For example, March 12, 2018 is formatted as Monday, March 12, 2018. No time indicator is displayed. |
|
Short Time |
Formats times as HH:MM AM/PM. For example, 2:04 PM is formatted as 2:04 PM. No date indicator is displayed. |
|
Long Time |
Formats times as HH:MM:SS AM/PM. For example, 2:04 PM is formatted as 2:04:00 PM. No date indicator is displayed. |
|
Full Date, Short Time |
Formats dates and times as Weekday, Month Date, Year HH:MM AM/PM. For example, 2:04 PM on March 12, 2018 is formatted as Monday, March 12, 2018 2:04 PM. |
|
Full Date, Long Time |
Formats dates and times as Weekday, Month Date, Year HH:MM:SS AM/PM. For example, 2:04 PM on March 12, 2018 is formatted as Monday, March 12, 2018 2:04:00 PM. |
|
General Date, Short Time |
Formats dates and times as MM/DD/YYYY, HH:MM AM/PM. For example, 2:04 PM on March 12, 2018 is formatted as 3/12/2018 2:04 PM. |
|
General Date, Long Time |
Formats dates and times as MM/DD/YYYY, HH:MM:SS AM/PM. For example, 2:04 PM on March 12, 2018 is formatted as 3/12/2018 2:04:00 PM. |
|
Universal Pattern |
Formats dates and times as YYYY-MM-DD HH:MM:SSZ. For example, 2:04 PM on March 12, 2018 is formatted as 2018-03-12 14:04:00Z. |