combine Month and Year

[TomBond77]

Hi expert

In the master item area (dimension) I need to create this result: for 12. May 2021 I expect: May-2021.

I have the following formula, it gives: May. Now I need the year.

=Month([Date] + [Days])

Thanks for your help.

Tom

[Dalton_Ruer]

Couple of ways to do it. You will see the expression in the table as the column label. Notice one retains a DATE datatype, while the other is a TEXT value. 

Typically I like assigning the TEXT approach in the LOAD script so I don't waste CPU calculations in the User Interface. And I use the TEXT approach so that I can do a DUAL of the text, and the number of the month for sorting purposes.

[TomBond77]

Thank you!

Additionally I need only the current month until the end in future. I don't want to see the past months and years. Can you please provide this code?