How to convert numbers into monthYear in Slider in Qlik Sence

[#1]

How to convert numbers into monthYear in Slider in Qlik Sence, like 42156 to Display as a MonthYear in  sence UI-slider

where I'm using MonthYear as dimension. but it keep showing numbers instead of 'Jan-2016'

Thanks in Advance

[Anonymous]

Hi

DATE() : for system number to date format

DATE# : for text to date format

So , use the following

=(Date(YOURDATEFIELD,'MMM-YY'))

And in the slider settings u also need the above format for each varaibale as MMM-YY

Edited one :.

[#3]

I tried that and many others just not working in qlik sence.

Thanks a lot