Target Format
Mandatory.
Specify the desired date format to be used by the virtual field nominated in the Virtual Field Name.
This is the date format that the virtual field is converting to.
Rules
Valid date format values are:
|
SYSFMT |
QDATFMT |
|
DDMMYY |
Day, Month and Year |
|
MMDDYY |
Month, Day and Year |
|
YYMMDD |
Year, Month and Day |
|
DDMMYYYY |
Day, Month, Century and Year |
|
MMDDYYYY |
Month, Day, Century and Year |
|
YYYYMMDD |
Century, Year, Month and Day |
|
YYMM |
Year and Month |
|
MMYY |
Month and Year |
|
MMYYYY |
Month, Century and Year |
|
YYYYMM |
Century, Year and Month |
|
SYSFMT8 |
QDATFMT including Century |
Warning
- If an alphanumeric date field (real or virtual) is being converted to a resulting numeric date field (real or virtual), a check will be automatically performed to ensure the resulting numeric date field contains all numeric characters (0 to 9). If the resulting numeric date field does not contain all numeric characters (i.e. alpha characters have been found) the resulting numeric date field will be set to 0.
Also See