Understand Date/Time Field Properties
This page is applicable to all report types except pivot chart and pivot table.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:
Related Topics
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
Still can't find what you're looking for?
Write to us: support@zohoforms.com
Zoho Sheet Resources
Zoho Forms Resources
Zoho Sign Resources
Sign, Paperless!
Zoho SalesIQ Resources
Zoho TeamInbox Resources
Zoho DataPrep Resources
Design. Discuss. Deliver.
Related Articles
Understand date-time field
The date-time field enables your users to enter a date and time. They can either use a date-time picker or type the required date and time. The date-time field displays the date and time values as per the date and time format set in your app's ...Understand date field
The date field enables your users to enter a date value. They can either use a date picker or type the required date value. The date field displays the date as per the date format and time zone set in your app's settings. Below is how a date field ...Understand time field
The time field enables your users to enter a valid time. They can either use a time picker or type the required time value. The time field displays time as per the time format and time zone set in your app's settings . Below is how a time field ...Set initial value for date, time, and date-time fields
To learn about these fields, refer to date , time , and date-time The date and time values are subject to the date and time format set in your app's settings Set initial value for date field Set initial value for time field Set initial value for ...Manage seconds for time and date-time fields
Refer to the following pages to learn about the Manage seconds property in the context of the time and date-time fields. Open the form builder. Select the required field. Its Field Properties will appear on the right. Navigate to the Time Picker - ...