Page 1 of 1

Adding Months to theExisting Months

Posted: Thu Jul 05, 2007 10:26 am
by irajasekharhexa
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

Posted: Thu Jul 05, 2007 11:46 am
by ray.wurlod
Download date routines from my website and use the AddMonths routine.

Posted: Tue Jul 17, 2007 6:07 am
by leo76
But how to call server routine in Parallel job transform

Posted: Tue Jul 17, 2007 4:43 pm
by DSguru2B
Basic Transformer.