Creating a date conversion field

  1. Specify the virtual field ID using the naming convention, &XXXX. Use option 1='Create'.
  2. 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.
  3. Select virtual field type 7-'Date'.
  4. Specify the Base date which are 1-'Current date', 2-'Object', 3-'Specific date'.
  5. Specify the Date output which are 1-'Date' YYYYMMDD, 2-'Day number', 3-'Working day number', 4-'Bank day number'.
  6. Press Enter.