Product: ImportOmatic
Description: This solution discusses how to include the current date in a virtual field using functions.
Environment: All
Versions: 2.2 and Higher


The current date or the date that the import is run can be added as a value in a date or comment field by using a function in a virtual field. To add the current date to a date field or a comment field using virtual fields:
  1. Open the profile in question through ImportOmatic Configuration
  2. Select Virtual Fields in the profile navigation pane of the profile that appears on the left hand side of the profile window
  3. Right Click in the screen to "Insert Virtual Column"
  4. Select the appropriate Record Type and Value Type
  5. Select the drop down in the "Function" column and select "Current Date"

This will allow the current date to be placed in the field indicated in the value type for the specific record type selected.

Refer to the ImportOmatic User Guide for additional information.