Date/Time format examples

The following are examples of user-defined date and time formats using the August 18, 2005 as an example.

Format string in
template formula

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)

FORMAT NOW, 'long date'

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:

Date/Time formats