Understand Date-time Field | Zoho Creator Help

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  settings . Below is how a date-time field looks on form:
  • When a user accesses from a web browser:

  • When a user accesses from a phone or tablet:

When to use this field

You may consider the following pointers to determine when to use a date-time field:

  • Use a date-time field if the data that you want to enable your users to enter is a particular date and time value according to the date and time format set in your app's settings
  • When you want to enable your users to enter just a date value, you must add a  date  field to your form
  • When you want to enable your users to enter just a time value, you must add a  time  field to your form.

Experience while entering data

  • When a user is using a web browser, clicking in the date-time field's input area will open the date-time picker. The current date comes highlighted, and the picker auto-selects the time at which the user opened the picker. Your user can select the required date and time in a few clicks.

  • When a user is using a phone/tablet, tapping in the date-time field's input area will open the date-time picker that auto-selects the current date and time. Your user can select the required date and time by individually selecting the month, date, year, hour, minutes and seconds, and then tapping  Done .

Features

You can perform the following customizations for the date-time field on a form:

Refer to  this  section to learn about the customizations for the date-time field in reports.

Set allowed days

You can customize the date-time field such that it accepts a date that falls on an allowed day of the week.  Learn how

For example, you may allow your users to select a date that falls on a Monday or Wednesday. When a user accesses this time field and selects a time that is not within the allowed hours, they will be prompted with an error message.

  • When a user accesses this date-time field from a web browser, dates that do not fall on a Monday or Wednesday will appear greyed out and will be disabled in the calendar. If a user types a date that does not fall on an allowed day, form submission will fail and the user will be prompted with an error message.
  • When a user accesses this date-time field from a phone/tablet, dates that do not fall on a Monday or Wednesday will appear greyed out and will be disabled in the calendar. The user can select a date that falls on an allowed day.

Set allowed hours

You can customize the date-time field such that it accepts a time that falls during the hours you allow.  Learn how .

For example, you may allow your users to select a time that falls between 10:00 to 16:00 (i.e., 10:00 am to 4:00 pm). When a user accesses this time field and selects a time that is not within the allowed hours, they will be prompted with an error message.

Hide or show seconds

By default, the seconds part is displayed by the time field. You can hide it in both—the form and its reports—by disabling the  Show seconds  field property. Learn  how to manage seconds for the date-time field.

When  Show seconds  is disabled and users access from a web browser, the seconds picker won’t appear in the date-time field. However, users are free to type the seconds part.

Below is an example of a date-time field in a list report that doesn't show seconds:

Set minutes interval

You can customize the time picker such that your users get to set the minutes part as per the interval you set. Learn  how to set minutes interval for time fields

Setting the minutes interval will not prevent users from entering a time that does not conform to the selected interval. However, when the typed minutes part does not adhere to the  Minutes interval  of that field, the input will automatically be rounded to the nearest acceptable value. For example, if your users enter 11:24 PM as the input, the time field will automatically set it as 11:20 PM; when they enter 11:26 PM, the time field will automatically set it as 11:30 PM.

Set initial value

Initial Value  for a date-time field refers to the date and time values that comes set when your users access your forms to submit an entry. The initial value can be either the current date and time or a particular date and time.  Learn how

For example, imagine that you are building an app to help your users book appointments, where the  Book an Appointment  form accepts details such as appointment date and time, visitor's name and purpose of visit. You can automate the capturing of visiting date and time by pre-defaulting that date-time field with the current date and time. This will also help your visitors save time and effort in filling out your form. This is achieved by selecting  zoho.currenttime  as that date-time field's initial value.

You can also pre-default the date-time field with the current date and let your users select the required time value. This is achieved by selecting  zoho.currentdate  as that date-time field's initial value. The time part will be set as 12:00 AM or 00:00 as per the time format set in your app's settings.

Setting an initial value will not prevent your users from entering a different date and time.

Other field properties

Report-level customizations

By default, when your users access a date-time field in  reports , they see the  Full Date . You can customize the appearance of the date values as follows:

  • Set the  Display Option : You can enable your users to view the  Full Date Day of month Month Year Week Day  (Monday, Tuesday, etc.),  Date Only , or  Time Only


    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 CRM Training
      Redefine the way you work
      with Zoho Workplace

        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 CRM Training

          Create, share, and deliver

          beautiful slides from anywhere.

          Get Started Now


            Zoho Sign now offers specialized one-on-one training for both administrators and developers.

            BOOK A SESSION








                                You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.




                                    Manage your brands on social media

                                      Zoho Desk Resources

                                      • Desk Community Learning Series


                                      • Digest


                                      • Functions


                                      • Meetups


                                      • Kbase


                                      • Resources


                                      • Glossary


                                      • Desk Marketplace


                                      • MVP Corner


                                      • Word of the Day


                                        Zoho Marketing Automation

                                          Zoho Sheet Resources

                                           

                                              Zoho Forms Resources


                                                Secure your business
                                                communication with Zoho Mail


                                                Mail on the move with
                                                Zoho Mail mobile application

                                                  Stay on top of your schedule
                                                  at all times


                                                  Carry your calendar with you
                                                  Anytime, anywhere




                                                        Zoho Sign Resources

                                                          Sign, Paperless!

                                                          Sign and send business documents on the go!

                                                          Get Started Now




                                                                  Zoho TeamInbox Resources



                                                                          Zoho DataPrep Resources



                                                                            Zoho DataPrep Demo

                                                                            Get a personalized demo or POC

                                                                            REGISTER NOW


                                                                              Design. Discuss. Deliver.

                                                                              Create visually engaging stories with Zoho Show.

                                                                              Get Started Now







                                                                                            You are currently viewing the help articles of Sprints 1.0. If you are a user of 2.0, please refer here.

                                                                                            You are currently viewing the help articles of Sprints 2.0. If you are a user of 1.0, please refer here.



                                                                                                  • Related Articles

                                                                                                  • Understand Date/Time Field Properties

                                                                                                    This page is applicable to all report types except pivot chart and pivot table. 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 ...
                                                                                                  • 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 in your app's settings. Below is how a time field looks on a form: When a ...
                                                                                                  • Understand prediction field

                                                                                                    The Prediction field uses Zoho's Artificial Intelligence (AI) to predict the value of a field in your form. It analyzes the data in your form, then uses machine learning to create a model that's capable of predicting a field value for all future ...
                                                                                                  • Understand prediction field

                                                                                                    AI Models have undergone a major revamp and is now rechristened as AI Modeler that lets you build, train, and publish models to be used across your apps. To know more, check out our new help pages. The Prediction field uses Zoho's Artificial ...
                                                                                                    Wherever you are is as good as
                                                                                                    your workplace

                                                                                                      Resources

                                                                                                      Videos

                                                                                                      Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                                                                      eBooks

                                                                                                      Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                                                                      Webinars

                                                                                                      Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                                                                      CRM Tips

                                                                                                      Make the most of Zoho CRM with these useful tips.



                                                                                                        Zoho Show Resources