How to substract two Date in transformer's contraints

bhargav_dd · Post by **bhargav_dd** » Thu Apr 14, 2011 5:03 am

I have two DATE to be compared in transformer's constraints,

As I need to make sure whether their difference is bigger than 2 year or not,

How to write the code, seems that there is no specific function for such a purpose,

GJ_Stage · Post by **GJ_Stage** » Thu Apr 14, 2011 5:14 am

Hi,

Below function will help your requirement :

YearFromDate(StringToDate(DATE_FIELD,"%yyyy%mm%dd")
then compare it.

chulett · Post by **chulett** » Thu Apr 14, 2011 6:44 am

One methodology - DATE datatypes can be subtracted to get a difference in days, then you can check to see if that difference is > 730.