. Eg:- R06=Tue 24 Mar 2020,Wed 10 Jun 2020 ,First_Date = Tue 24 Mar 2020, Second_Date = Wed 10 Jun 2020 then compare those date into the Verifed_Date
taking verified date as present date
Date Compare:- if(First_Date.before(Verifed_Date ) consider the value as 1, else if(First_Date.equals(Verifed_Date ) consider the values as 0, else consider the r value as 2; if D2_ExecutionDate is null or empty mean verified should be null .
a). (Date Compare(Verifed_Date ,First_Date == 0 || Verifed_Date ,First_Date == 1) && (Verifed_Date ,Second_Date == 2 || Verifed_Date, Second_Date == 0)) get the verified values from PhaseMapping verified = R06.1
can you please help me to write query for Datecompare and a).I tried with eval command..