Creating a date conversion field
- Specify the virtual field ID using the naming convention, &XXXX. Use option 1='Create'.
- Specify the column heading by either specifying a description or a message ID. If specifying a description, you can defined the column heading per language by pressing the language button. If specifying a message ID, the column heading is automatically displayed in the end user's M3 language.
- Select virtual field type 7-'Date'.
- Specify the Base date which are 1-'Current date', 2-'Object', 3-'Specific date'.
- Specify the Date output which are 1-'Date' YYYYMMDD, 2-'Day number', 3-'Working day number', 4-'Bank day number'.
- Press Enter.