DSXchange

Hi All,

I have a requirement for a Date field in one of my DataSTage job where I need to do a (DATE - 6 months) function.
The Input Source is a flat file & we need to perform this calculation before getting the data loaded to the Target Table.

Setting an example of the scenario here, It would be (17-05-2011) - 6 months.I tried searching the forum, but was not able to find any posts related to this.
Any help will be greatly appreciated.

Thanks,
Freddie

There are basically two approaches. One is to perform arithmetic on the individual components, the other is to use something like DateFromDaysSince() function with an offset of -183 days (a close approximation to six months).