...
Insert excerpt
DateTime Formatting Options
The output of DateTime fields can be formatted to show as much or as little information as is required. IMOS offers a formatting selector for the most common formats, but you can also construct your own DateTime format using a combination of codes. Continue past the table for examples of custom formatted date options.
Formatting Code | Formatting Selector Option | Formatting Output |
|---|---|---|
d | Short date | 2-digit Day-Short Month-2-digit Year 01-Oct-13 |
D | Long date | Long Weekday, Long Month 2-digit Day, 4-digit Year Wednesday, June 12, 2013 |
f | Full date, short time | Long Weekday, Long Month 2-digit Day, 4-digit Year Hours:Minutes AM|PM Wednesday, June 12, 2013 8:00 AM |
F | Full date, long time | Long Weekday, Long Month 2-digit Day, 4-digit Year Hours:Minutes:Seconds AM|PM Wednesday, June 12, 2013 8:00:00 AM |
g | General date, short time | 2-digit Day-Short Month-2-digit Year Hours:Minutes AM|PM 12-Jun-13 8:00 AM |
G | General date, long time | 2-digit Day-Short Month-2-digit Year Hours:Minutes:Seconds AM|PM 12-Jun-13 8:00:00 AM |
m | Month, day | Long Month, 2-digit Day June 12 |
t | Short time | Hours:Minutes AM|PM 8:00 AM |
T | Long time | Hours:Minutes:Seconds AM|PM 12:30:45 PM |
y | Year, month | Long month, 4-digit Year October, 2013 |
yyyy | - | 4-digit Year 2013 |
yy | - | 2-digit Year 13 |
dd | - | 2-digit Day 12 |
ddd | - | Short Weekday Tue |
dddd | - | Long Weekday Tuesday |
MM | - | 2-digit Month 09 |
MMM | - | Short Month Sep |
MMMM | - | Long Month September |
Custom DateTime Formatting
You can create a custom DateTime formatting using the above codes that do not appear in the Formatting Selector field. To create custom formatting codes, type the preferred codes in the Formatting Code field. You can also include other characters to display in the output. For simple characters like - and , you can just type the character, but wrap more complex characters in "".
Here are some examples:
Formatting Code | Formatting Output |
|---|---|
yyyy-MM-dd | 1986-03-14 |
"Year: "yyyy", Month: "MMMM", Day: "dd | Year: 2013, Month: June, Day: 12 |
MMMM dd, yyyy | March 14, 2016 |
Numeric Formatting Options
Formatting Code | Description | Formatting Selector Option | Formatting Output |
|---|---|---|---|
0 | Digit | - |
| Sample pattern: 0 31.24 → 31 Sample pattern: #.00 1.234 → 1.23 Sample pattern: 0.00% 0.1555 → 15.55% Sample pattern: #,###.00 | ||
- | Digit, zero shows as absent | ||
. | Position of the decimal point | ||
, | Group separator for thousands | ||
% | Shows number as a percentage. | ||
C | Formats as a currency, including decimal, thousands separators, and currency symbol. | Currency | $53,121.00 |
F | Rounds decimal values to 2 digits. | Fixed-point | 5344.00 |
G | General formatting with no thousands separators, and decimal output depending on decimal value. | General | 8964.02481 |
N | Formats with thousands separators and 2-digit fixed decimals. | Number | 9,431.25 |
P | Value is multiplied by 100. Formats with thousands separators and 2-digit decimals, with a % symbol. | Percent | 94,312,500.00 % |