Tom England Posted January 7, 2002 Share Posted January 7, 2002 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. Link to comment Share on other sites More sharing options...
LiveOak Posted January 7, 2002 Share Posted January 7, 2002 NextMonth (calculation, text) = MonthName(Date(Mod(Month(CurrentDate) + 1, 12), 1, 1)) & " " & Case(Month(CurrentDate) = 12, Year(CurrentDate) + 1, Year(CurrentDate)) -bd Link to comment Share on other sites More sharing options...
Thom Posted January 8, 2002 Share Posted January 8, 2002 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. Link to comment Share on other sites More sharing options...
Tom England Posted January 9, 2002 Author Share Posted January 9, 2002 That's great. Thanks Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8164 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now