DataGridTextBoxColumn()??

  • Thread starter Thread starter Darryn Ross
  • Start date Start date
D

Darryn Ross

Hi,

Can anyone please tell me how to format a DataGridTextBoxColumn() into a
short date format?? i have formatted all my other fields but can't seem to
get the date one figured out.

Thankz

Darryn
 
The following table describes the standard format specifiers for formatting
the DateTime object.

Format specifier Name Description
d Short date pattern Displays a pattern defined by the
DateTimeFormatInfo.ShortDatePattern property associated with the current
thread or by a specified format provider.
D Long date pattern Displays a pattern defined by the
DateTimeFormatInfo.LongDatePattern property associated with the current
thread or by a specified format provider.
t Short time pattern Displays a pattern defined by the
DateTimeFormatInfo.ShortTimePattern property associated with the current
thread or by a specified format provider.
T Long time pattern Displays a pattern defined by the
DateTimeFormatInfo.LongTimePattern property associated with the current
thread or by a specified format provider.
f Full date/time pattern (short time) Displays a combination of the
long date and short time patterns, separated by a space.
F Full date/time pattern (long time) Displays a pattern defined by the
DateTimeFormatInfo.FullDateTimePattern property associated with the current
thread or by a specified format provider.
g General date/time pattern (short time) Displays a combination of the
short date and short time patterns, separated by a space.
G General date/time pattern (long time) Displays a combination of the
short date and long time patterns, separated by a space.
M or m Month day pattern Displays a pattern defined by the
DateTimeFormatInfo.MonthDayPattern property associated with the current
thread or by a specified format provider.
R or r RFC1123 pattern Displays a pattern defined by the
DateTimeFormatInfo.RFC1123Pattern property associated with the current
thread or by a specified format provider. This is a defined standard and the
property is read-only; therefore, it is always the same regardless of the
culture used, or the format provider supplied. The property references the
CultureInfo.InvariantCulture property and follows the custom pattern "ddd,
dd MMM yyyy HH:mm:ss G\MT". Note that the 'M' in "GMT" needs an escape
character so it is not interpreted. Formatting does not modify the value of
the DateTime; therefore, you must adjust the value to GMT before formatting.
s Sortable date/time pattern; conforms to ISO 8601 Displays a pattern
defined by the DateTimeFormatInfo.SortableDateTimePattern property
associated with the current thread or by a specified format provider. The
property references the CultureInfo.InvariantCulture property, and the
format follows the custom pattern "yyyy-MM-ddTHH:mm:ss".
u Universal sortable date/time pattern Displays a pattern defined by
the DateTimeFormatInfo.UniversalSortableDateTimePattern property associated
with the current thread or by a specified format provider. Because it is a
defined standard and the property is read-only, the pattern is always the
same regardless of culture or format provider. Formatting follows the custom
pattern "yyyy-MM-dd HH:mm:ssZ". No time zone conversion is done when the
date and time is formatted; therefore, convert a local date and time to
universal time before using this format specifier.
U Universal sortable date/time pattern Displays a pattern defined by
the DateTimeFormatInfo.FullDateTimePattern property associated with the
current thread or by a specified format provider. Note that the time
displayed is for the universal, rather than local time.
Y or y Year month pattern Displays a pattern defined by the
DateTimeFormatInfo.YearMonthPattern property associated with the current
thread or by a specified format provider.
Any other single character Unknown specifier



use DataGridTextBoxColumn.Format property to get the required format.
 
Back
Top