Adding months to a date

PEFS

I am assuming that this is very simple but I have read through all of the date and time functions and can't seem to figure out how to do this. I have a need to add a specific amount of months to a date attribute (this would be calculated):

DateOfOrder = 7/1/2009 <---date the user enters
DateOfReview = 10/1/2009 <----date that should be calculated by the system.

I have done this by adding days but that is obviously not an exact science (since not all months have the same number of days).

Any ideas?

Thanks!

PEFS

I have to agree with the other forum users post about getting an answer a few minutes after you post...:o)

Here's what I did to get the result and it works stellar (of course if there is a better way I would like to know)

Orders.DateOfReview=DATE(DAY_OF_MONTH (Orders.DateOfOrder),MONTH (Orders.DateOfOrder)+3,YEAR (Orders.DateOfOrder))

PEFS

robinsz

What about orders placed on the 31st of the month ... and the review 3 months later the month only has 30 days in it

What about orders placed in month 11 ... 11+3=14, setting a date with "14" in the month column wont work

in SQL it would be SET orders.DateOfReview = DATE_ADD(orders.DateOfOrder, INTERVAL 3 MONTH); which would automatically handle crossign month/year boundaries, etc etc .. unsure what that looks like in an AwareIM rule as im a newb to AwareIM

Actually, this does hint slightly of the sin of "caching of derived data" .. probably better to set a rule for calculating the review date from the order date rather than wrting it into the table.

aware_support

The new build with a new function that allows to add months properly is coming soon (within a day or two). It has been implemented already.

aware_support

Build 1229 now has MONTH_ADD function that adds months properly