Wednesday, September 22, 2010

DateTime Custom Picture Formatting

Using Picture Formats for Custom Formatting

The standard format specifiers are useful in most cases whilst still maintaining the correct style of date and time for the user's location. On some occasions however, it is necessary to have complete control over the positioning and styling of each element of date and time information.

For this, picture formats must be used. These allow an exact format to be created using any combination of elements from a DateTime.

DateTime theDate = DateTime.Parse("3 Jan 2007 21:25:30");
string result;

result = theDate.ToString("d-MM-yy");//result ="3-01-07"
result = theDate.ToString("HH:mm");//result ="21:25"
result = theDate.ToString("h:mm tt");//result ="9:25 PM"

Available Picture Formatting Codes

The above example shows several formats and the results. The full list of available formatting codes is as follows:
SpecifierDescriptionExamples
yOne-digit year. If the year cannot be specified in one digit then two digits are used automatically."7"
"95"
yyTwo-digit year with leading zeroes if required."07"
yyyyFull four-digit year."2007"
g or ggIndicator of Anno Domini (AD)."A.D."
MOne-digit month number. If the month cannot be specified in one digit then two digits are used automatically."1"
"12"
MMTwo-digit month number with leading zeroes if required."01"
MMMThree letter month abbreviation."Jan"
MMMMMonth name."January"
dOne-digit day number. If the day cannot be specified in one digit then two digits are used automatically."3"
"31"
ddTwo-digit day number with leading zeroes if required."03"
dddThree letter day name abbreviation."Wed"
ddddDay name."Wednesday"
hOne-digit hour using the twelve hour clock. If the hour cannot be specified in one digit then two digits are used automatically."9"
"12"
hhTwo-digit hour using the twelve hour clock with leading zeroes if required."09"
HOne-digit hour using the twenty four hour clock. If the hour cannot be specified in one digit then two digits are used automatically."1"
"21"
HHTwo-digit hour using the twenty four hour clock with leading zeroes if required."09"
tSingle letter indicator of AM or PM, generally for use with twelve hour clock values."A"
"P"
ttTwo letter indicator of AM or PM, generally for use with twelve hour clock values."AM"
"PM"
mOne-digit minute. If the minute cannot be specified in one digit then two digits are used automatically."1"
"15"
mmTwo-digit minute with leading zeroes if required."01"
sOne-digit second. If the second cannot be specified in one digit then two digits are used automatically."1"
"59"
ssTwo-digit second with leading zeroes if required."01"
fFraction of a second. Up to seven f's can be included to determine the number of decimal places to display."0"
"0000000"
zOne-digit time zone offset indicating the difference in hours between local time and UTC time. If the offset cannot be specified in one digit then two digits are used automatically."+6"
"-1"
zzTwo-digit time zone offset indicating the difference in hours between local time and UTC time with leading zeroes if required."+06"
zzzFull time zone offset indicating the difference in hours and minutes between local time and UTC time with leading zeroes if required."+06:00"

Some of the formatting codes use the same letter as a format specifier. When used within a format string that is greater than one character in length this does not present a problem.

If you need to use a single character picture format string, the letter must be preceded by a percentage sign (%) to indicate that the standard format specifier is not to be used.

DateTime theDate = DateTime.Parse("3 Jan 2007 21:25:30");
string result;

result = theDate.ToString("d");// result = "03/01/2007"
result = theDate.ToString("%d");// result = "3"

No comments:

Method 'StartWorkflowOnListItem' in type 'Microsoft.SharePoint.WorkflowServices.FabricWorkflowInstanceProvider'

Exception: Method 'StartWorkflowOnListItem' in type 'Microsoft.SharePoint.WorkflowServices.FabricWorkflowInstanceProvider'...