Date Bump Help 1

[Rseven]

sort of a tricky question.

I have a bunch of due dates, that are monthly. I need to bump the due date on a monthly basis until greater than conversion date (2/7/2011)

example: 6/1/09, with conversion date of 2/7/11, would need 3/1/11.

example 2: 7/15/10 with conversion date of 2/7/11, would need to be bumped to 3/15/2011.

Any help would be greatly appreciated!

 

[Lilliabeth]

DateAdd("m",DateDiff("m",[due date],#2/7/2011#)+1,[due date])




--Lilliabeth

 

[Rseven]

Lilliabeth,

Absolutely awesome!! I had something similar but had the dateadd and datediff functions reversed and couldn't figure it out for the life of me.

Thank you so much, this saves me hours of work!