SAP Knowledge Base Article - Public

2651824 - Calculated field in Integration Center - compare DateTime field to "Now"

Symptom

You are trying to build a calculated field and the Calculation need to include an IF/THEN Statement with a comparison of:

  • Lastmodified <= "Now "

How can you set the "Now" as a Parameter in the IF?

Environment

SuccessFactors - Integration Center

Resolution

The solution for the calculated field comparing datetime field in the "IF/THEN" condition is using the <NOW> keyword. This is the expected format.

Find in the screenshots below the examples =  01.PNG  (less than "now")   and 02.PNG  (greater than "now").

01)

less.PNG

 

02)

greater.PNG

The NOW calculation works if the Field Data Type is set to DateTime. Do not use String for this case.

Keywords

Integration Center, calculated field, DateTime greater than now, DateTime less than now, Compare DateTime field , KBA , LOD-SF-INT-INC , Integration Center , LOD-SF-INT , Integrations , How To

Product

SAP SuccessFactors HXM Suite all versions