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.
Comments
-
Follow Us
