Date comparison in tranformer

Benny Domeij · Post by **Benny Domeij** » Fri Oct 24, 2008 4:35 am

I wonder why this expression only give me 'N' for column forny although I get rows with different valid_from_date2 and valid_from_date:
if DSLink247.valid_from_date2<>DSLink247.valid_from_date then 'J' else 'N'

valid_from_date2 and valid_from_date are in date format.

Althaf6553 · Post by **Althaf6553** » Fri Oct 24, 2008 5:26 am

Please check with the data formats on both sides while doing comparision
i mean <dd-mm-yyy:hh:mm:nn>

chulett · Post by **chulett** » Fri Oct 24, 2008 7:07 am

Not only the same format but one that allows comparison: either the internal numeric format or the ISO external format YYYY-MM-DD.