Date Display Format Tricks

Time Date Signature, Insert Date Time, and Quick Text Hotkeys all allow you to specify a date/time format.  The add-in provides a drop down list that allows you to select a pre-defined date format.  What most people don’t realize is that they can type directly in that box to specify a custom format.  I get a lot of people asking how they can get the format to display in a specific way.  I hope that the information provided here will help answer your questions.Here is a list of formats that can be used:

  •  d – day of the month, no leading zero (1-30 (or 31))
  • dd – day of month, with leading zero (01-30 (or 31))
  • ddd – day of the week, short form (like Mon, Tue, Wed)
  • dddd – day of the week, long form (like Monday, Tuesday, Wednesday)
  • w – week of the year, no leading zero (1-51)
  • ww – week of the year, with leading zero (01-51)
  • m – month, no leading zero (1-12)
  • mm – month, with leading zero (01-12)
  • mmm – full month name, short (like Oct, Nov, Dec)
  • mmmm – full month name, long (like October, November, December)
  • y – day of the year
  • yy – two digit year
  • yyyy – four digit year
  • h – hours
  • hh – hours with leading zero
  • n – minutes
  • nn – minutes with leading zero
  • s – seconds
  • ss – seconds with leading zero
  • AMPM – Appends “AM” or “PM” to the time; if this is left off, you get military time

Here are a few examples of how to use these formats for  December 1, 2008 at 1:05 PM:

  • m/d/yy -> 12/1/08
  • h:nn AMPM -> 1:05 PM  
  • dddd, mmmm d, yyyy -> Thursday, December 1, 2008
  • h:nn -> 13:05 

This trick really comes in handy for our European customers trying to get the time and date in a format they are used to.  This allows great flexibility to the formats for use and provides a way to display the information in just about any way you can think of.

Look smart! Share this article with your colleagues and friends: