Created Date: 10/22/2018 1:26:18 PM | User Level: Regular User

The time in the system can be either in AM/PM (civilian time) or in Military time (00:00 through 23:59). This comes down to a business decision on how you wish to display the information for your users. All of the time within the system ultimately is saved in UTC time with no time zone information. This allows us to display the time based on a company or a user profile setting.

If you go into Settings / App Setup you can change the way time is shown throughout the system. Once there you will be on the General tab. Beneath that there is a section called Grid & Date/Time Format. Choose this tab. Below you will find guides that can be used for a quick copy/paste to change to the format you want. If you wish to modify from the formats this will also help guide you through the process to meet your unique needs.

Civilian Time (Default)

Date Format (Default)
- $('#{{FIELD}}').datetimepicker({ format: 'Y-m-d', timepicker: false });
Date/Time Format (Calculated Times) (Default)
- $('#{{FIELD}}').datetimepicker({ format: 'Y-m-d h:i A', datepicker: true, timepicker: true, formatTime: 'h:i A', step: 60 });
Date/Time Format (Specifying Times)
- $('#{{FIELD}}').datetimepicker({ format: 'Y-m-d h:i A', datepicker: true, timepicker: true, allowTimes: ['00:00', '01:00', '02:00', '03:00', '04:00', '05:00', '06:00', '07:00', '08:00', '09:00', '10:00', '11:00', '12:00', '13:00', '14:00', '15:00', '16:00', '17:00', '18:00', '19:00', '20:00', '21:00', '22:00', '23:00'] });
Time Format (Calculated Times) (Default)
- $('#{{FIELD}}').datetimepicker({ format: 'Y-m-d h:i A', datepicker: false, timepicker: true, formatTime: 'h:i A', step: 60 });
Time Format (Specifying Times)
- $('#{{FIELD}}').datetimepicker({ format: 'h:i A', datepicker: false, timepicker: true, allowTimes: ['00:00', '01:00', '02:00', '03:00', '04:00', '05:00', '06:00', '07:00', '08:00', '09:00', '10:00', '11:00', '12:00', '13:00', '14:00', '15:00', '16:00', '17:00', '18:00', '19:00', '20:00', '21:00', '22:00', '23:00'] });

Military Time

Date Format
- $('#{{FIELD}}').datetimepicker({ format: 'Y-m-d', timepicker: false });
Date Formatted
- $('#{{FIELD}}').datetimepicker({ format: 'Y-m-d h:i', datepicker: true, timepicker: true, formatTime: 'h:i A', step: 60 });
Date/Time Format (Calculated Times)
- $('#{{FIELD}}').datetimepicker({ format: 'Y-m-d H:i', datepicker: true, timepicker: true, allowTimes:['00:00', '01:00', '02:00', '03:00', '04:00', '05:00', '06:00', '07:00', '08:00', '09:00', '10:00', '11:00', '12:00', '13:00', '14:00', '15:00', '16:00', '17:00', '18:00', '19:00', '20:00', '21:00', '22:00', '23:00'] });
Time Format
- $('#{{FIELD}}').datetimepicker({ format: 'Y-m-d h:i', datepicker: false, timepicker: true, formatTime: 'h:i A', step: 60 });
Time Format (Calculated Times)
- $('#{{FIELD}}').datetimepicker({ format: 'Y-m-d H:i', datepicker: false, timepicker: true, allowTimes:['00:00', '01:00', '02:00', '03:00', '04:00', '05:00', '06:00', '07:00', '08:00', '09:00', '10:00', '11:00', '12:00', '13:00', '14:00', '15:00', '16:00', '17:00', '18:00', '19:00', '20:00', '21:00', '22:00', '23:00'] });

Additional Notes

Step: On the "step:" and a number starting at 1 that is the number for each minute. Being we use 60 as our default you will have your times every one hour. If you used 15 as the value you would see times every fifteen minutes (e.g., :00, :15, :30, :45) for the times. The key here is the lower the number will make your list longer.
Format: In the format option, 'h' represents the hour in 12-hour format and 'A' represents the AM/PM designation.
Allowed Times: Additionally, if you want to provide a list of allowed times, you can use the allowTimes option to specify them. Make sure to adjust the format and allowTimes options according to your specific requirements. By configuring the format option with the 'A' specifier and providing the allowTimes option with AM/PM formatted times, the Date and Time Picker will display and accept time values in the desired AM/PM format.