Solved: Have a problem with the Date function. - Qlik Community

Report Inappropriate Content · ‎2017-01-30

This is my actual data and I want it in this form:

But what I see in Qlikview is

...

How can I get the data in that format

tresesco · ‎2017-01-30

When creating date in the script, finally put date() around your expression like:

Load

Date( YourCurrentDateField, 'MMM-YYYY') as NewDate

tresesco · ‎2017-01-30

When creating date in the script, finally put date() around your expression like:

Load

Date( YourCurrentDateField, 'MMM-YYYY') as NewDate

vinieme12 · ‎2017-01-30

go to number tab >> Select Date >> Edit format to MMM-YYYY

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

Chanty4u · ‎2017-02-02

or else try with

Date(Date#(DateField,'MMM-YYYY'),'MMM-YYYY') as NewDate