Common date, time, and numeric formats
Many formatting options are available for the date, time, and numeric values in your reports.
Each of the following tables describe a subset of format options by type. For some formats, examples are provided to show the difference between similar formats. To learn more about the formats in these tables or view the complete list of formats, review the following Microsoft article: Formatting Types
Common standard date and time formats
|
Format specifier |
Description |
|---|---|
|
d |
Short date Example: 6/15/2019 |
|
D |
Long date Example: Monday, June 15, 2009 |
|
f |
Full date and time with short time Example: Monday, June 15, 2019 1:45 PM |
|
F |
Full date and time with long time Example: Monday, June 15, 2019 1:45:30 PM |
|
g |
General date and time with short time Example: 2/12/2019 3:54 PM |
|
G |
General date and time with long time Example: 2/12/2019 3:54:30 PM |
|
t |
Short time Example: 1:45 PM |
|
T |
Long time Example: 1:45:30 PM |
|
Y or y |
Year and month Example: June 2009 |
Common custom date and time formats
|
Format specifier |
Description |
|---|---|
|
M |
Month. Single-digit months do not have a leading zero |
|
MM |
Month. Single-digit months have a leading zero |
|
MMM |
Abbreviated name of the month |
|
MMMM |
Full name of the month |
|
d |
Day of the month. Single-digit days do not have a leading zero |
|
dd |
Day of the month. Single-digit days have a leading zero |
|
ddd |
Abbreviated name of the day of the week |
|
dddd |
Full name of the day of the week |
|
y |
Year without the century. Single-digit years do not have a leading zero |
|
yy |
Year without the century. Single-digit years have a leading zero |
|
yyyy |
Year with the century |
|
hh |
Hour using a 12-hour clock. Single-digit hours have a leading zero |
|
HH |
Hour using a 24-hour clock from 00 to 23. Single-digit hours have a leading zero |
|
mm |
Minutes. Single-digit minutes have a leading zero |
|
ss |
Seconds. Single-digit seconds have a leading zero |
|
fff |
Milliseconds in a date and time value |
|
tt |
AM/PM designator |
Common custom numeric formats
|
Format specifier |
Description |
|---|---|
|
N0 or n0 |
Number with no decimal places and 1000 separator Example: 1,235 |
|
N2 or n2 |
Number with two decimal places and 1000 separator Example: 1235.46 |
|
C0 or c0 |
Currency value with no decimal places and 1000 separator Example: $1234 |
|
C2 or c2 |
Currency value with two decimal places and 1000 separator Example: $1234.56 |
|
P2 or p2 |
Number displayed with a percent symbol with two decimal places Example: 100.00% |