I have a timestamp field. I want the field to contain the most recent timestamp after importing a file and updating the existing records in found set. I'm trying to do this by validating by calculation. I would think that a simple IF function would be sufficient however I can't seem to figure out how to reference the data that's being imported. I would think the IF statement would look something like this pseudocode below:
IF (IMPORTED_TIMESTAMP > CURRENT_TIMESTAMP ; IMPORTED_TIMESTAMP ; CURRENT_TIMESTAMP)
Any thoughts?? Any help is greatly appreciated!!!