AnsweredAssumed Answered

How do I do a timestamp comparison?

Question asked by jake.swift on Oct 9, 2017
Latest reply on Oct 13, 2017 by jake.swift

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!!!

Outcomes