topic Re: Make Date Formatting in QlikView

Make Date Formatting

caniwhz1 — Tue, 20 Mar 2018 12:14:11 GMT

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 — Tue, 20 Mar 2018 12:58:18 GMT

Hi,

try this:

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

caniwhz1 — Tue, 20 Mar 2018 13:04:12 GMT

Thank you. It works.

Have a nice day.

Cathleen

YoussefBelloum — Tue, 20 Mar 2018 13:06:01 GMT

you're welcome.

Good luck