To identify the months between first month and end month

pavithra_12 · Post by **pavithra_12** » Wed Jan 18, 2006 5:06 am

Hi,

I have an requirement as to find the months between the first month and end month using a tranformer to load the measure for the corresponding month.

- Pavithra

loveojha2 · Post by **loveojha2** » Wed Jan 18, 2006 5:13 am

I think you are talking about a range lookup

Search the Forum with the term "range lookup".

Hope this is what you are looking for.

kumar_s · Post by **kumar_s** » Wed Jan 18, 2006 6:08 am

Hi Pavitra,

Is it Number of Months between two dates?

-Kumar

ray.wurlod · Post by **ray.wurlod** » Wed Jan 18, 2006 3:10 pm

Should this be a decimal number (3.4 months) or an integer number of completed months (3 months)?

It's easiest done with a routine. I'm sure you can construct the algorithm. Do so (on paper), then try translating into DataStage BASIC.

dssiddu · Post by **dssiddu** » Wed Jan 18, 2006 11:39 pm

hi

u can use generic date ds transforms.....