The following are examples of user-defined date and time formats using the August 18, 2005 as an example.
The formats for GainSeeker Charts and Dynamic reports modules may differ. See Date/Time format examples for these modules.
|
Format string in |
Output when regional options are set to: |
|
|
English (United States) |
Italian (Italy) |
|
|
m/d/yy |
8/18/05 |
8/18/05 |
|
d-mmm |
18-Aug |
18-ago |
|
d-mmmm-yy |
18-August-05 |
18-agosto-05 |
|
d mmmm |
18 August |
18 agosto |
|
mmmm yy |
August 05 |
agosto 05 |
|
hh:nn AM/PM |
03:28 PM |
03.28 PM |
|
h:nn:ss a/p |
3:28:10 p |
3.28.10 p |
|
h:nn |
15:28 |
15.28 |
|
h:nn:ss |
15:28:10 |
15.28.10 |
|
m/d/yy h:nn |
8/18/05 15:28 |
8/18/05 15.28 |
The following are examples of template formulas for various date/time formats for August 18, 2005:
|
Template formula |
Output when regional options are set to: |
|
|
English (United States) |
Italian (Italy) |
|
|
Thursday, August 18, 2005 |
giovedì 18 agosto 2005 |
|
|
FORMAT NOW, 'c' |
8/18/2005 3:28:10 PM |
18/08/2005 15.28.10 |
|
FORMAT NOW, 'short date' |
8/18/2005 |
18/08/2005 |
|
FORMAT NOW, 'ddd","dd mmm yy' |
Thu, 18 Aug 05 |
gio, 18 ago 05 |
|
FORMAT NOW, 'ddd","dd mmm yy h:nn a/p' |
Thu, 18 Aug 05 3:28 p |
gio, 18 ago 05 3.28 p |
More: