Guys,
I need to get Resultdate which is in between Two dates like below.
FS.ResultDate BETWEEN PH.EffectiveStartDate AND PH.EndDate
any suggestions how this can be done. I was using below logic.
DSLink300.ResultDate >= DSLink300.EffectiveStartDate And DSLink300.ResultDate<= DSLink300.EndDate
Doesnt work though any thougths appreciated. Is there any Function like Between in Datastage.
Thanks
Sri
Capture Between Date from 2 Dates
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 40
- Joined: Thu Jul 10, 2008 12:45 pm
Capture Between Date from 2 Dates
Srikanth Reddy
Integration Consultant
Integration Consultant
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: