You are here: LANSA for i User Guide > 3. Files > 3.15 Virtual Fields > 3 15 7 Date Conversion of a Field

3.15.7 Date Conversion of a Field

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.

 

 

 DC@P201608            Date conversion of a field                      

                                                                       

 File : XXXXXXXXXX  XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX       (XXXX )

                                                                       

 Virtual field : XXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX   

                                                                       

 Derive "virtual" field on input from file . . .  ___ YES, NO          

 Setup "real" field before output to file  . . .  ___ YES, NO          

                                                                       

 "Real" field to convert from  . . . . . . . . .  __________           

                                                                       

 "Virtual" field date format is  . . . . . . . .  ________             

                                                                       

 "Real" field date format is . . . . . . . . . .  ________             

                                                                       

                                                                       

 Fnn=Help  Fnn=Exit  Fnn=Cancel  Fnn=Messages  Fnn=Change  Fnn=Delete  

                                                                       

 

 

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)

Notes