Changing Date/Time Formatting Dropdown Formatting

 Created Date: 10/22/2018 1:26:18 PM |  User Level: Regular User |  Views: 3,617

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.


Available Service Flyers

Our philosophy has always been honesty (this is our rule #1) and transparency in our services. There's no reason to hide costs unless you have something to hide. We've found that those who hide fees charge more successful businesses more money because they can. We do not feel this is the way America was meant to be. We believe in offering a fair price to everyone for the work that is done.

We also believe that once you sign on with us, you trust us, and as our thank you to you, we "price lock" our services for the plan(s) you signed up for at that time. This means while you are on those services, the price will always be the same. As business owners, we appreciate this as it allows us to budget our business expenses better.