ghudson
Registered User.
- Local time
- Today, 02:34
- Joined
- Jun 8, 2002
- Messages
- 6,195
I have a text field "CurrentMonth" that will always be the full name of a month. Example (January, March, ext.) I am pulling the data into a text box in a report like this...
=[CurrentMonth]
I can also pull it in like this using the format function to ensure it is read as a month date.
=Format([CurrentMonth],"mmmm")
How can I add one month to the data value so that value will always be the next month. Example: a January value should be displayed in the text box as February.
Thanks in advance for your help!
=[CurrentMonth]
I can also pull it in like this using the format function to ensure it is read as a month date.
=Format([CurrentMonth],"mmmm")
How can I add one month to the data value so that value will always be the next month. Example: a January value should be displayed in the text box as February.
Thanks in advance for your help!
Last edited: