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.
Date comparison in tranformer
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 6
- Joined: Mon Mar 07, 2005 2:43 am
-
- Participant
- Posts: 64
- Joined: Wed Sep 26, 2007 6:52 am
- Location: Syracuse ,NY