| Note: | This task applies only to an Enterprise Database Server database that is mapped to SQL. An Enterprise Database Server item defined as a true DATE data type cannot be manipulated in this manner. |
Perform the following steps to model dates for a data set:
-
From the tree view, expand the server containing the database you want to modify.
-
Expand the desired data set and select the Dates folder.
An input form appears in the properties view.
-
Type a name for the date column in the Date Column Name box. The name is used to reference this column in SQL statements.
-
In the Date Format group, select the format that represents how the data in the Enterprise Database Server data item is actually formatted.
-
Depending on the date format selected, different input fields appear on the input form.
-
The input form contains the Item Name list and the Base Year box if you select one of the following formats:
1-Item MMDDYY 1-Item YYMMDD 1-Item DDMMYY 1-Item DDDYY 1-Item YYYDD
Select an item from the Item Name list that corresponds to the date. If the selected date format contains a 2-digit year, the Base Year box is enabled. The Base Year box displays the reference year from which to interpret the 2-digit year.
For example, if the base year is 1957, the years from 57 through 99 are interpreted as 1957 to 1999, while the years from 00 through 56 are interpreted as 2000 through 2056.
-
The input form contains only the Item Name list if you select one of the following formats:
1-Item MMDDYYYY 1-Item YYYYMMDD 1-Item DDMMYYYY 1-Item DDDYYYY 1-Item YYYYDDD
Select an item from the Item Name list that corresponds to the date.
-
The input form contains the Year Item list, Day Item list, and Base Year box if you select the 2-Item Date format.
-
Select an item from the Year Item list that corresponds to the year.
-
Select an item from the Day Item list that corresponds to the day.
-
Specify a base year to use in the Base Year box.
-
-
The input form contains the Year Item list, Month Item list, Day Item list, and Base Year box if you select the 3-Item Date format.
-
Select an item from the Year Item list that corresponds to the year.
-
Select an item from the Month Item list that corresponds to the month.
-
Select an item from the Day list that corresponds to the day.
-
Specify a base year in the Base Year box or use the default value.
-
-
-
Click Store to create an SQL date.
The date is added to the tree view immediately and the date is added to the database schema when you apply modifications to the database. Refer to Applying Schema Modifications earlier in this section for details.
