Make Date Formatting

[caniwhz1]

Hi,

I use the following formula to create a date filed as a new dimension:

=MakeDate(JahrT,num(month(date#(MonatT,'MMM'))))

The result is 01.01.2017. But I need, for example, the following result: January 2017.

Thank you very much in advance for help.

Cathleen

[YoussefBelloum · Accepted solution]

Hi,

try this:

=Date(MakeDate(JahrT,num(month(date#(MonatT,'MMM')))),'MMMM YYYY')

[caniwhz1]

Thank you. It works.

Have a nice day.

Cathleen

[YoussefBelloum]

you're welcome.

Good luck