This screen is displayed when the option to perform a Date conversion for a virtual field has been chosen from the Virtual field extended definition action box.
|
Working from the Date conversion of a field screen you can:
Input Options
File
Is the name of the physical file currently being worked with.
Virtual Field
Is the name of the "virtual" field within the physical file currently being worked with. The value of the "virtual" field will be the result of the date conversion from the "real" field. The "virtual" field must be large enough to contain the result of/value for the date conversion otherwise unpredictable results could occur.
Derive "Virtual" Field on Input from File
Specifies whether the "virtual" field should be derived from the "real" field ("real" field can be either a "real" or "virtual" field name within this file) on input from file. Valid entries are "YES" or "NO".
Setup "Real" Field Before Output to File
Specifies whether the "real" field ("real" field can be either a "real" or "virtual" field name within this file) should be setup before output to file. Valid entries are "YES" or "NO".
"Real" Field to Convert from
Specifies the name of the field ("real" or "virtual" field name within this file) to be used for the date conversion to the resulting "virtual" field. The "real" field must be large enough to contain the result of/value for the date conversion otherwise unpredictable results could occur.
By entering a partial name or a '?' the single field selection screen will be displayed. The selection list will be built from the real and virtual fields in the current file's definition. Refer to 3.10.1 Select Fields When Working from File Definition Menu for more details.
"Virtual" Field Date Format Is
Specifies the date format to be used to convert the specified "real" field ("real" or "virtual" field name within this file) to the value of the "virtual" field. Valid date format values for this field are as follows:
SYSFMT |
(QDATFMT) |
SYSFMT8 |
(8 digit date in QDATFMT format) |
DDMMYY |
(Day, Month and Year) |
MMDDYY |
(Month, Day and Year) |
YYMMDD |
(Year, Month and Day) |
DDMMYYYY |
(Day, Month and Full Year) |
MMDDYYYY |
(Month, Day and Full Year) |
YYYYMMDD |
(Full Year, Month and Day) |
YYMM |
(Year and Month) |
MMYY |
(Month and Year) |
YYYYMM |
(Full Year and Month) |
MMYYYY |
(Month and Full Year) |
"Real" field date format is
Specifies the date format of the "real" field ("real" or "virtual" name within this file). Valid date format values for this field are as follows:
SYSFMT |
(QDATFMT) |
SYSFMT8 |
(8 digit date in QDATFMT format) |
DDMMYY |
(Day, Month and Year) |
MMDDYY |
(Month, Day and Year) |
YYMMDD |
(Year, Month and Day) |
DDMMYYYY |
(Day, Month and Full Year) |
MMDDYYYY |
(Month, Day and Full Year) |
YYYYMMDD |
(Full Year, Month and Day) |
YYMM |
(Year and Month) |
MMYY |
(Month and Year) |
YYYYMM |
(Full Year and Month) |
MMYYYY |
(Month and Full Year) |
CYYMMDD |
(Century indicator, Year, Month and Day) |