Adding month to current date

deva · Post by **deva** » Tue Jan 09, 2007 10:39 am

Hi all,
Please advise me how to add one month to current date.

Please let me know if there is any function.

We are using Datastage 7.1 server
Os windows xp.
DB oracle

Thanks in advance

DSguru2B · Post by **DSguru2B** » Tue Jan 09, 2007 10:42 am

Nothing out of the box. You can click on Ray's footer that will take you to his page. He has a routine that will solve your problem.

kcbland · Post by **kcbland** » Tue Jan 09, 2007 10:44 am

Define one month. If today is 2007-01-31, do you expect 2007-02-28? If it's 2007-02-28, do you expect 2007-03-31? You need to be very clear. Simply incrementing the month and potentially the year doesn't handle the varying days in a month. You need to be clear on "date rounding".

Otherwise, there's functions already posted on ths forum to do almost exactly what you're asking. Use the Search facility.

deva · Post by **deva** » Tue Jan 09, 2007 11:01 am

DSguru2B wrote:Nothing out of the box. You can click on Ray's footer that will take you to his page. He has a routine that will solve your problem.

I am not getting any page. Could you please give me the copy of that routine

DSguru2B · Post by **DSguru2B** » Tue Jan 09, 2007 11:06 am

Search for a link on this page. It has a few routines, including the one that you want.

ray.wurlod · Post by **ray.wurlod** » Tue Jan 09, 2007 1:29 pm

I was about to suggest the very same page!

DSXchange

Adding month to current date

Adding month to current date

Please help me