DSXchange

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

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.

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

tahnks
Krish