Character | Comments |
---|---|
d | day of month without leading zero for single digits |
dd | day of month with leading zero for single digits. |
ddd | day of week as a three letter abbreviation |
dddd | full name of day of week |
M | month without leading zero for single digit |
MM | month with leading zero for single digit |
MMM | month as three letter abbreviation. |
MMMM | full name of month |
yy | last two digits of year |
yyyy | full four digits of year |
h | hours without leading zeros for single digits (12 hour) |
hh | hours without leading zeros for single digits (12 hour). |
H | hours without leading zeros for single digits (24 hour) |
HH | hours with leading zeros for single digits (24 hour) |
m | minutes without leading zeros for single digits |
mm | minutes with leading zeros for single digits |
s | seconds without leading zeros for single digits |
ss | seconds with leading zeros for single digits |
t, tt | single character or multiple character a.m./p.m. string |
Date, Time, or DateTime value | Format String | Resulting String |
---|---|---|
CDate(1996, 11, 1) | yy MMM dd, dddd | 96 Nov 01, Friday |
CTime(12, 10, 10) | HH*mm*ss tt | 12*10*10 |
CDateTime(1995, 10, 12, 3, 30, 11) | HH:mm, yy MMMM ddd | 03:30, 96 October Mon |
CTime(13, 20, 22) | hh 'h' mm 'min' ss 'sec' tt | 01 h 20 min 22 sec |
CDate(1998, 3, 17) | M/dd/yy | 3/17/98 |
SAP BusinessObjects http://www.sap.com/sapbusinessobjects/ Support services http://service.sap.com/bosap-support/ Product Documentation on the Web http://help.sap.com/ |