>how can I add one month to the date?
>
>eg: today is 08/04/2009, the due date is 09/04/2009.
>I can get the 09/04/2009, no need to count if I have to add today with 30 or 31 days.
>
>thanks for the help
>
>Jerry
Look at GOMONTH() function in Help.
GOMONTH(date(),1)
If it's not broken, fix it until it is.
My Blog