Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
caniwhz1
Contributor III
Contributor III

Make Date Formatting

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

1 Solution

Accepted Solutions
YoussefBelloum
Champion
Champion

Hi,

try this:

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

View solution in original post

3 Replies
YoussefBelloum
Champion
Champion

Hi,

try this:

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

caniwhz1
Contributor III
Contributor III
Author

Thank you. It works.

Have a nice day.

Cathleen

YoussefBelloum
Champion
Champion

you're welcome.

Good luck