Setting Date Formats in One Model

How to set Date Formats for data.

Date Formats for data that is referenced in One Model can be set in the company page:

This allows users one place to set date formats for any data that is exported from the One Model application

We recommend by default using the following Date Formats:

  • Date Format: YYYY-MM-DD

  • Date and Time Format: YYYY-MM-DD HH:mm:ssZ

These show the date in a format that translates across many more nationalities than m/d/yyyy (common for the USA), or d/m/yyyy (common for Australia). 

Supported Date Formats

Several other formats are possible by editing the available tokens. The full list of available tokens can be found here:

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 ... 30 31 

Day of Year 

  • "DDD": 1 2 ... 364 365  

  • "DDDo": 1st 2nd ... 364th 365th  

  • "DDDD": 001 002 ... 364 365 

Day of 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 Week (Locale) 

  • "e": 0 1 ... 5 6 

Day of Week (ISO) 

  • "E": 1 2 ... 6 7 

Week of Year 

  • "w": 1 2 ... 52 53  

  • "wo": 1st 2nd ... 52nd 53rd  

  • "ww": 01 02 ... 52 53 

Week of Year (ISO) 

  • "W": 1 2 ... 52 53  

  • "Wo": 1st 2nd ... 52nd 53rd  

  • "WW": 01 02 ... 52 53 

Year 

  • "YY": 70 71 ... 29 30

  • "YYYY": 1970 1971 ... 2029 2030 

  • "Y": 1970 1971 ... 9999 +10000 +10001

  • "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

Time Zone

  • "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?

0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.