DSXchange

Posted: **Thu May 26, 2011 2:03 pm**

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

Posted: **Thu May 26, 2011 4:54 pm**

What does "doesn't work" in this contect? Where are you using this expression? What do you expect it to produce?

DSXchange

Capture Between Date from 2 Dates

Capture Between Date from 2 Dates