FORMATS

FormatDate(str,fmt)

FormatDate(str,fmt) forces the format of dates and times

Identifier

 

Meaning

d

 

Displays the number of the day without a leading 0 (1 to 31)

dd

 

Displays the number of the day with a leading 0 (01 to 31)

ddd

 

Displays the abbreviation of the day (Sun to Sat)

dddd

 

Displays the full name of the day (Sunday to Saturday)

m

 

Displays the number of the month without a leading 0 (1 to 12)

mm

 

Displays the number of the month with a leading 0 (01 to 12)

mmm

 

Displays the abbreviation of the month (Jan to Dec)

mmmm

 

Displays the full name of the month (January to December)

yy

 

Displays the year with two digits (00 to 99)

yyyy

 

Displays the year with four digits (0000-9999)

h

 

Displays the time (hour) without a leading 0 (0 to 23)

hh

 

Displays the time (hour) with a leading 0 (00 to 23)

n

 

Displays the minutes without a leading 0 (0 to 59)

nn

 

Displays the minutes with a leading 0 (00 to 59)

s

 

Displays the seconds without a leading 0 (0 to 59)

ss

 

Displays the seconds with a leading 0 (00 to 59)


 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Last Update: 16.12.2004