yearmonth

[akashnandwana]

Hello,

My one of the filed name YearMonth is in the format of 2022-Dec, I want expression in the form of next month i.e my o/p should be 2023-jan.

Many Thanks

[rubenmarin]

Hi, if that value is a date, not a string, you can use Date(AddMonths(YearMonth,1),'YYYY-MMM').

If it's a text you can use: Text(Date(AddMonths(Date#(YearMonth,'YYYY-MMM'),1),'YYYY-MMM'))

[akashnandwana · Accepted solution]

Thank you for the reply

It didn't work but I tried another way.

Thank you so much