See GOMONTH() function
ldNewDate = GOMONTH(ldOldDate,1)
>I have a date field and need to advance by one month.
>
>I thought that just adding one month would work and does for dates like
>
>4/15/2009 ........ 5/15/2009
>
>However if i have 3/31/2009 and advance by one month will give me a blank date because there is no 4/31/2009
>
>
>if MONTH(ldOldDate) < 12
> ldNewDate = DATE(YEAR(ldOldDate),MONTH(ldOldDate)+1,DAY(ldOldDate))
>else
> ldNewDate = DATE(YEAR(ldOldDate)+1,MONTH(1),DAY(ldOldDate))
>endif
>
>
>Any suggestion to accomplish this would be appreciated.
--sb--