Bikeman17 Posted January 18, 2005 Posted January 18, 2005 Hi there, I want to get a calc field that will display the month name in two months ahead. If I use this calc, I know that January will be displayed: MonthName(Status( CurrentDate)) What about March? Mike
Ugo DI LUCA Posted January 18, 2005 Posted January 18, 2005 Have a try with : MonthName(Date(Month(Status(CurrentDate))+2;1;Status(CurrentYear)))
Bikeman17 Posted January 18, 2005 Author Posted January 18, 2005 Bonjour Ugo, There was a small glitch in the cal. I had to replace CurrentYear by CurrentDate. After I fixed the detail, I endend up with an empty field. In fact, the result should be March
Ugo DI LUCA Posted January 18, 2005 Posted January 18, 2005 Nope Should be : MonthName(Date(Month(Status(CurrentDate))+2;1;Year(Status(CurrentDate)))) Sorry about that.
Recommended Posts
This topic is 7318 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