Full month not showing up

[emp166]

I am trying to have output of an expression (=MonthName(AddMonths(Today(),2))) be the month name but the output is Jun 2023. can someone please help me identify an alternate expression that will give the full month name? 

[sandeep-singh]

Try this

Date(MonthName(AddMonths(Today(),2)),'MMMM')

if you want to add years, then use this

Date(MonthName(AddMonths(Today(),2)),'MMMM YYYY')

[Rams-]

Hi,

If you want only June you can try this:

Date(MonthName(AddMonths(Today(),2)),'MMMM')

If you want June 2023, you can try:

Date(MonthName(AddMonths(Today(),2)),'MMMM YYYY')

If you want June 23, you can try:

Date(MonthName(AddMonths(Today(),2)),'MMMM YY')

Hope this helps,

help user find answers ! don't forget to mark  a solution that work for you and click the like button!