Date Comparisons Transform

[chandramohan27 (Chandra Mohan S)]

Hi Experts,

I have dateTime value coming from 4 different source, what would be the best approach to calculate the latest dateTime out of 4 values.

[gourab (Gourab Sadhukhan)]

Hi @chandramohan27 ,
I found a similar posr here:

Retrieve farthest date out of multiple date attribute from different source

I have similar requirements, I need to calculate identity end date , which is going to be the farthest value out of {(attribute1, source1),{attribute 3, source 2),{attribute 3, source3)}. example: attribute1: 2022-05-10 attribute2: 2022-05-11 attribute3: 2022-05-12 output: 2022-05-12 could you please help me how to write complex rule or transform for this. thanks in advance

[Santhakumar (Shantha Kumar)]

Hi @chandramohan27 You can use the static and date transforms as @gourab mentioned. While creating the transform make sure you don’t have any null values because it will through an error when you map it on the Identity Profiles.