Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
varunreddy
Creator III
Creator III

Date Conversion

Hi All,

I have dates in the following format:

1-1-2016

2-1-2016

3-1-2016

2016/April,

2016/May

Now I want to convert this into Month Year (i.e. May 2016).

Can anyone help me with this?

Thanks in advance!

Regards,

Varun

1 Solution

Accepted Solutions
sunny_talwar

May be like this:

MonthName(Alt(Date#(DateField, 'D-M-YYYY'), Date#(DateField, 'YYYY/MMM'))) as MonthYear

View solution in original post

3 Replies
sunny_talwar

May be like this:

MonthName(Alt(Date#(DateField, 'D-M-YYYY'), Date#(DateField, 'YYYY/MMM'))) as MonthYear

varunreddy
Creator III
Creator III
Author

Sunny this equation is displaying dates with the format May/2016.

It is not displaying dates with 1/1/2016

varunreddy
Creator III
Creator III
Author

Sunny,

Got it.

Thanks for the quick response.

Cheers,

Varun