Date Comparing in Transformer

mtechnocrat · Post by **mtechnocrat** » Wed Apr 12, 2006 6:15 am

HI All

Is it possible two compare two dates in transformer , which are having the same format.
My requirement is If Get_Date < Run Date I need to insert into old file Else new file . The date format is MM/DD/YYYY HH24:MI:SS .
When the both date fields having same year this logic is working fine, if the the both date fileds having diffrent years the data was going to wrong file.

Can you help to reslove this issue ?

Thanks in advance

Krish

chulett · Post by **chulett** » Wed Apr 12, 2006 6:25 am

In that format? No. You need to either get them both in 'YYYY-MM-DD' format or convert them to internal format (using IConv) before you compare them.

mtechnocrat · Post by **mtechnocrat** » Wed Apr 12, 2006 7:11 am

Thanks CHulett.
I ahve chnaged the format , now the data is going as per the logic to old file and new file.

tahnks
Krish