Date format
Previous  Top  Next

The following characters in the "Date format" field have the special meaning:
d   Displays the day as a number without a leading zero (1-31).  
dd   Displays the day as a number with a leading zero (01-31).  
m   Displays the month as a number without a leading zero (1-12). If the m specifier immediately follows    an h or hh specifier, the minute rather than the month is displayed.  
mm   Displays the month as a number with a leading zero (01-12). If the mm specifier immediately follows    an h or hh specifier, the minute rather than the month is displayed.  
yy   Displays the year as a two-digit number (00-99).  
yyyy   Displays the year as a four-digit number (0000-9999).  
h   Displays the hour without a leading zero (0-23).  
hh   Displays the hour with a leading zero (00-23).  
n   Displays the minute without a leading zero (0-59).  
nn   Displays the minute with a leading zero (00-59).  
s   Displays the second without a leading zero (0-59).  
ss   Displays the second with a leading zero (00-59).  
z   Displays the millisecond without a leading zero (0-999).  
zzz   Displays the millisecond with a leading zero (000-999).