Filter
Top Products
Defining display formats
236 DataWindow .NET
Table 8-4: Characters with special meaning in data display formats
Colons, slashes, and spaces display as entered in the mask.
About 2-digit years
If users specify a 2-digit year in a DataWindow object, DataWindow Designer
assumes the date is the 20th century if the year is greater than or equal to 50. If
the year is less than 50, DataWindow Designer assumes the 21st century. For
example:
• 1/1/85 is interpreted as January 1, 1985.
• 1/1/40 is interpreted as January 1, 2040.
Date keywords
You can use the following keywords as date display formats when you want
DataWindow Designer to determine an appropriate format to use:
•
[ShortDate]
• [LongDate]
The format used is determined by the regional settings for date in the registry.
Note that
[Date] is not a valid display format.
Examples
Table 8-5 shows how the date Friday, January 30, 1998, displays when
different format masks are applied.
Character Meaning Example
d Day number with no leading zero 9
dd Day number with leading zero if appropriate 09
ddd Day name abbreviation Mon
dddd Day name Monday
m Month number with no leading zero 6
mm Month number with leading zero if appropriate 06
mmm Month name abbreviation Jun
mmmm Month name June
yy Two-digit year 97
yyyy Four-digit year 1997