Next Month

[Tom England]

I apologise for posting another date related Topic!

I want a field to show next month just as a Month and Year. eg, February 2002. Once in February it should show March 2002.

[LiveOak]

NextMonth (calculation, text) =

MonthName(Date(Mod(Month(CurrentDate) + 1, 12), 1, 1))

& " " &

Case(Month(CurrentDate) = 12, Year(CurrentDate) + 1, Year(CurrentDate))

-bd

[Thom]

monthNext(calc,date,unstored) =

Date(Month(Status(CurrentDate)), 1, Year(Status(CurrentDate)))

Change the field's Date Format to Custom to show only month name and year.

[Tom England]

That's great.

Thanks