Date setting Description
From Windows Control Panel As defined in Regional Settings. The value is taken from
the Short Date Style box on the Date tab, or its equivalent
entry on your version of the Windows operating system.
You can change this setting on the General tab of the
Preferences property sheet, accessible from the File menu.
When new columns are created using this setting, the Date
Input Format shown on the Column property sheet
mirrors the Windows Control Panel setting.
Date Codes
To specify a date format that exactly matches that used in your source data, on the
Time tab of the Column property sheet, choose one of the following Date Input
Format settings.
Date input format setting Description
YMD Year, Month, Day; for example, 070413 or 2007-Apr-13
DMY Day, Month, Year; for example, 130407 or 13 Apr 2007
MDY Month, Day, Year; for example, 041307 or Apr 13, 2007
YM Year, Month: for example, 200704 or 2007-Apr. This setting
is processed as if the day component were 01.
MY
Month, Year; for example, 042007.
This setting is processed as if the day component were 01.
Y
Year; for example, 2007.
This setting is processed as if the month and day
components were 01.
To construct dates consisting of years, quarters, months, or days, use the following
codes.
Date code Description
YY A 2-digit year; for example, 07
YYYY A 4-digit year; for example, 2007
Q A 1-digit quarter; for example, 1
MM A 2-digit month; for example, 01
MMM The abbreviated month name; for example, Jan
MMMM The full month name; for example, January
DD A 2-digit day; for example, 01
DDDD A day of the week; for example, Sunday
/, -, or a space character Alternate separator; for example, 2007/01/01 or 2007-01-01
Any quoted string The quoted string; for example, "(" shows an open
parenthesis
324 IBM Cognos Transformer Version 10.1.1: User Guide
To Next Page
Need help?
General