Date Range Validation
Posted: Wed Mar 31, 2010 3:24 am
hi,
I need to check wthether the Effective date is in between the Start date and end date cloumn. here is the example.
Eff date Start Date End date
20091231 20081231 20111231
20071231 20081231 20111231
For the above records, i need to pick up the first record as Eff date is beetween the start date and End date. my source is file . how check the range ttrougt the transformer stage.
Thanks in Advance
I need to check wthether the Effective date is in between the Start date and end date cloumn. here is the example.
Eff date Start Date End date
20091231 20081231 20111231
20071231 20081231 20111231
For the above records, i need to pick up the first record as Eff date is beetween the start date and End date. my source is file . how check the range ttrougt the transformer stage.
Thanks in Advance