Table_A
PROD1, MFGSTARTDATE, MFGENDDATE
Table_B
PROD1, QADATE
I have to pass the records only when the 'QADATE' is
between 'MFGSTARTDATE' and 'MFGENDDATE'
Can anyone tell me which stage to use to achive this.
Thanks in advance.
Search found 1 match
- Wed Oct 18, 2006 10:03 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to do look for the greater than or less than date ranges
- Replies: 7
- Views: 3125