How to Add Months In DataStage

Vinodanand · Post by **Vinodanand** » Tue Apr 04, 2006 12:46 am

Hi,

Is there a function in datastage server which can add months,something similar to ADD_Months function in Oracle.

I need to increment months based on an index ...

Can anyone help me out on this...

ray.wurlod · Post by **ray.wurlod** » Tue Apr 04, 2006 1:50 am

There is no out of the box function. It is easy enough to write one.

Add Int(Months/12) to the years.

Add Mod(Months,12) to the months.

Adjust if the new months figure is greater than 12.

Adjust by subtracting days if the number of days in the new month is illegal.

Vinodanand · Post by **Vinodanand** » Tue Apr 04, 2006 3:46 am

ray.wurlod wrote: There is no out of the box function. It is easy enough to write one.
Add Int(Months/12) to the years.

Add Mod(Months,12) ...

Hi,

Thnx ray... But What i want to know is , assume i have a running counter and i need to increase my month by adding the counter to it.

i.e. month= 03 and counter = 01 for 1st run

Therefore : when x = month + counter = 03 +1 = 04.

run 2 : month = 03 counter = 02

when x = month + counter = 03 +2 = 05.

Is there any function which could add months based on a counter...

kumar_s · Post by **kumar_s** » Tue Apr 04, 2006 4:17 am

Or you can workaround with Iconv/Oconv.
'Oconv(Iconv(date,"D"),DM) + counter' to add up the month.

pneumalin · Post by **pneumalin** » Tue Apr 04, 2006 8:41 am

Why don't you create c routine to do it. The time sructure will allow you to do everything about manipulating the date.

ray.wurlod · Post by **ray.wurlod** » Tue Apr 04, 2006 2:50 pm

If you've already got months and counter, then

Code: Select all

If (months + counter > 12) Then months + counter - 12 Else months + counter

assuming months + counter can never be less than 1 or more than 24. All data types are uint8 or a larger or signed integer.