Adding Months to theExisting Months

irajasekharhexa · Post by **irajasekharhexa** » Thu Jul 05, 2007 10:26 am

Hi,

In one of my Job I need to add exactly 3 months days to the existing date.

Suppose if the Incoming date is coming as 2007-01-01 then output date should be 2007-04-01

So for this I can use MonthFromDate function to extract the Month from the input date and adding 3 value for that doesn't give the accurate results. Since everymonth has different no.of days.

So any sugessions please to achive the accurate 3 months days(According to Corresponding no.of days from the respective month) addition to the existing Date?

Thanks

ray.wurlod · Post by **ray.wurlod** » Thu Jul 05, 2007 11:46 am

Download date routines from my website and use the AddMonths routine.

leo76 · Post by **leo76** » Tue Jul 17, 2007 6:07 am

But how to call server routine in Parallel job transform

DSguru2B · Post by **DSguru2B** » Tue Jul 17, 2007 4:43 pm

Basic Transformer.