January 7, 200224 yr 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.
January 7, 200224 yr NextMonth (calculation, text) = MonthName(Date(Mod(Month(CurrentDate) + 1, 12), 1, 1)) & " " & Case(Month(CurrentDate) = 12, Year(CurrentDate) + 1, Year(CurrentDate)) -bd
January 8, 200224 yr 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.
Create an account or sign in to comment