Configuring Date Time Field Format Tokens
- 26 Jan 2022
- 2 Minutes to read
- Print
- DarkLight
This documentation version is deprecated, please click here for the latest version.
Configuring Date Time Field Format Tokens
- Updated on 26 Jan 2022
- 2 Minutes to read
- Print
- DarkLight
Article summary
Did you find this summary helpful?
Thank you for your feedback
Overview
Unique to Simple Forms, the Date Time Field control may display date and/or time in a variety of formats matching formal tokens of programs such as MomentJS.
To customize the date time format, open a Date Time Field's Properties, navigate to the Setup Data section and set the Override Date Format checkbox to True. The Date Format Textbox will now appear to accept the format tokens.
A Validation error will show when attempting to use a token not appropriate in the control. Depending on the data type, only certain tokens are supported:
- Date only accepts date tokens (M,Q,D,d,w,y,etc.)
- Time only accepts time tokens (A,a,H,h,m,s,etc.)
- Date Time accepts both
Available Format Tokens
The following table describes various Date Time Field formats and the outputs that will display to the end-user.
| Date/Time Counter | Token | Output |
|---|---|---|
| Month | M | 1, 2, ... 11, 12 |
| Mo | 1st, 2nd, ... 11th, 12th | |
| MM | 01, 02, ... 11, 12 | |
| MMM | Jan, Feb, ... Nov, Dec | |
| MMMM | January, February, ... November, December | |
| Quarter | Q | 1, 2, 3, 4 |
| Qo | 1st, 2nd, 3rd, 4th | |
| Day of Month | D | 1, 2, ... 30, 31 |
| Do | 1st, 2nd, ... 30th, 31st | |
| DD | 01, 02, ... 20, 31 | |
| Day of Year | DDD | 1, 2, ... 364, 365 |
| DDDo | 1st, 2nd, ... 364th, 365th | |
| DDDD | 001, 002, ... 364, 365 | |
| Day of the Week | d | 0, 1, ... 5, 6 |
| do | 0th, 1st, ... 5th, 6th | |
| dd | Su, Mo, ... Fr, Sa | |
| ddd | Sun, Mon, ... Fri, Sat | |
| dddd | Sunday, Monday, ... Friday, Saturday | |
| Day of the Week (Locale) | e | 0, 1, ... 5, 6 |
| Day of the Week (ISO) | E | 1, 2, ... 6, 7 |
| Week of the Year | w | 1, 2, ... 52, 53 |
| wo | 1st, 2nd, ... 52nd, 53rd | |
| ww | 01, 02, ... 52, 53 | |
| Weeks of the Year (ISO) | W | 1, 2, ... 52, 53 |
| Wo | 1st, 2nd, ... 52nd, 53rd | |
| WW | 01, 02, ... 52, 53 | |
Year | Y | 1970, 1971, ... 9999, +10000, +10001 Note: This complies with the ISO 8601 standard for dates past the year 9999 |
| YY | 70,71, ... 29, 30 | |
| YYYY | 1970, 1971, ... 2029, 2030 | |
| YYYYYY | -001970, -001971, ... +001907, +001971 Note: Expanded Years that cover the full time value range of approximately 273,790 years forward or backward from January 1st, 1970) | |
| Week Year | gg | 70, 71, ... 29, 30 |
| gggg | 1970, 1971, ... 2029, 2030 | |
| Week Year (ISO) | GG | 70, 71, ... 29, 30 |
| GGGG | 1970, 1971, ... 2029, 2030 | |
| AM/PM | A | AM, PM |
| a | am, pm | |
| Hour | H | 0, 1, ... 22, 23 |
| HH | 00, 01, ... 22, 23 | |
| h | 1, 2, ... 11, 12 | |
| hh | 01, 02, ... 11, 12 | |
| k | 1, 2, ... 23, 24 | |
| kk | 01, 02, ... 23, 24 | |
| Minute | m | 0, 1, ... 58, 59 |
| mm | 00, 01, ... 58, 59 | |
| Second | s | 0,1, ... 58, 59 |
| ss | 00, 01, ... 58, 59 | |
| Fractional Second | S | 0, 1, ... 8, 9 |
| SS | 00, 01, ... 98, 99 | |
| SSS | 000, 001, ... 998, 999 | |
| SSSS...SSSSSSSSS | 000[0..], 001[0..], ... 998[0..], 999[0..] | |
| Timezone | z / zz | EST, CST, ... MST, PST Note: As of MomentJS 1.6.0, the z/zz format tokens have been deprecated from plain moment objects. Read more about it here. However, they *do* work if you are using a specific time zone with the moment-timezone addon. |
| Z | -07:00, -06:00, ... +06:00, +07:00 | |
| ZZ | -0700, -0600, ... +0600, +0700 | |
| Unix Timestamp | X | 1360013296 |
| Unix Millisecond Timestamp | x | 1360013296123 |
Was this article helpful?
