Date Range Fields enable you to set a duration of time with a start and end value. 

The start and end values, similar to Date/Time Fields, hold a date, hour, and minute value. 

Sample Date Range Field:

date-range-field-sample.png

Creating a date range field

To add a new date range field to your data table, click on the Date field type category on the Add Field menu and select the date range field type from the drop-down list.

add-date-range-feild.png

When creating a Date Range field, there are several settings you can customize such as those highlighted in the image below.

date-range-field-new.png

  1. Name- this is where you can name your Date Range field. For instance, "Vacation Request" or "Appointment Time".

  2. Description- this is where you can optionally provide a brief description of this field for your own reference. 

  3. End Date/Time Format- this is where you can choose the formatting for how the end date and time will be entered on a form component. While the Start Date Format will always display as a date/time field on forms, you have the option to prompt your users to select an End Date/Time Format of either a Date/Time field, Time Field, or Duration Field.

    At default, end date/time formatting is set to show a Date/Time field. on forms This means that on a form component, users will be prompted to choose an end date and time with a date/time field format. Keeping the End Date/Time Format as the default Date/Time field formatting is useful for when you would like to prompt your users to select a date and time as the end date on a form. For instance, if you have an Employee Management application where users can request time off, you would choose the default date/time field as the end date/time format to enable users to select a date and time for their last vacation day. 

    ez-gif-date-range-datetime-gif.gif

    There may be circumstances when you want to prompt your users to select a Duration field as their end date/time on a form. This can be useful in circumstances when the end date is the same and the start date and you want to prompt users to select a specific time duration as the end date/time. For instance, if you have an appointment scheduler application to coordinate appointments for a doctor's office, you would choose the Duration field as the end date/time format to enable employees/schedulers to schedule appointments with specific time duration such as 30 minute appointments or 1 hour appointments.

    ezgif-date-range-duration-gif.gif


    Alternatively, there may be circumstances when you want to prompt your users to select a Time field as their end date/time on a form. This can be useful in circumstances where the end date is the same date as the start date and you want to prompt users to select a specific time as the end date/time. For instance, if you have an Event Management application and would like to schedule events that are contracted to end at specific times on the event day, you would choose the Time field end date/time format to display a date/time field as the start date and only a time field as the end date.

    ezgif-date-range-time-gif.gif

    End Date/Time Format settings will only affect how end date/time fields are entered on a form. This setting does not affect how end date/time fields saved within a form will be displayed when viewed within other components. When displayed, both start and end values will be displayed as date/time fields.