Understand date/time field properties
The date, time, and, date-time field values are displayed as per the date and time format set in your app's settings. These values can be customized at the report-level as shown below:
For the date and date-time fields
You can customize the display option of the date and date-time field values in reports as follows:
Display option | Date field | Date-Time Field |
Full date | 05-Feb-2018 | 17-Mar-2018 15:46:32 |
Day of Month | 5 | 17 |
Month | February | March |
Year | 2018 | 2018 |
Week Day | Monday | Saturday |
Month & Year | February & 2018 | March & 2018 |
Date only | - | 03-Apr-2018 |
Time only | - | 14:32:58 |
For the time and date-time fields
You can choose to hide the seconds part of the time and date-time fields in reports. This is defined by the show seconds field property.
Show seconds field property | Date-time Field | Time Field |
Enabled | 17-Mar-2018 15:46:32 | 18:35:10 |
Disabled | 17-Mar-2018 12:45 | 10:10 |
Below is an example of a date-time field in a list report that doesn't show seconds: