Date Addition

[bmnaidu]

How do we add a specific number of months to a date?
Similarly Days and Years.

Please help me.

Thanks in advance.

[ArndW]

In order to do anything with dates you will need to convert them from display to internal format; the most common way is to use the ICONV() function with the appropriate Date conversion [see the manual under "conversions" for details]. When you do have that integer date you can perform simple math and, once finished, can convert that back into a display date.
Another way is that you can use ICONV() to get the year, month and day numbers for a date as well. Then add the months (check for going into the next year) and use OCONV() to put these numbers back into a display date.

[bmnaidu]

Thanks for info ArndW. I'll try. But I wonder if there is no function for manipulating dates. Is that are we missing any function or there is no function or API to handle such things.

[DSguru2B]

I wrote a routine once to add days, hours, mins, seconds, upto milliseconds. Click here and check out the very last post.
As for adding months, its really depends upon your own requirements. Adding a month could mean adding either 30 days or 31 days or 28 days for Feb, OR it could mean just incrementing the month counter by 1. So it really depends.

[clshore]

As has been discussed before, if you are doing date-month math, you need to define what happens in cases like this:

Jan 31, 2006 + 1 month = ???

Is it Feb 28, 2006?

What about:

Feb 28, 2006 - 1 month = ???

Is it Jan 28, 2006, or Jan 31, 2006?

Carter

[bmnaidu]

Thanks for the suggestions. Can you please help me how to call that routine?

[DSguru2B]

What routine are you referring to. If its mine then its all there in the description.