How do I add 1 month to the current month value and show the name of that future month?
The month one month from today:
TEXT((EOMONTH(TODAY(), 0) + DAY(TODAY())), "MMMM")
Unexpected results may occur if today is January 29, 30, or 31.
Can this be virtual? Its saying - “Invalid date”
Well i changed type = “Text” Now all say “December”
I just realized - i needed to say this. This needs to come from a [date] column in my table
It can be virtual.
You said you wanted the month name, not a date. Change your column type to Text.
Ok. It is working. However i need it to show the next month from the [date] column in my table.
It is basically just saying one from from November. I need it to look at the [date] column and give the month name from that.
Try:
TEXT((EOMONTH([Date], 0) + 1), "MMMM")
Perfect. That worked. But now i am thinking my user may want to see the year as well - in text form. Is that possible?
I imagine you can figure it out:
Thank Steve - as usual you got it!
1 Like