Brigham Berry

Updated October 04, 2021 20:58

Why is my date format looking strange?

Follow

I set my date format as MM/DD/YYYY but my days are triple digit numbers why is this?

• Official comment

  

  Brigham Berry October 04, 2021 21:09 (Edited October 05, 2021 15:52)

  The date format operators are case sensitive, when you capitalize DD it will give you the day of the year ie: 01-365. A lower case dd will give you the day of the month 01-31.

  Comment actions Permalink
• 

  Brigham Berry October 04, 2021 21:46

  Here is a cheat sheet of all the different date operators. The minimum number of digits will correspond to the number of letters you put for example MM will produce a two digit month, dd will give you a two digit day of the month, DDD will give you a three digit day of the year, etc. Separate multiple operators with any symbol such as / or - : MM-dd-YYYY, M/d/YY, dd,MM,YYYY 

  

  0

  Comment actions Permalink

Please sign in to leave a comment.