topic Have a problem with the Date function. in QlikView

Have a problem with the Date function.

Wed, 25 Nov 2020 16:16:04 GMT

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

tresB — Mon, 30 Jan 2017 10:02:29 GMT

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

Load

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

vinieme12 — Mon, 30 Jan 2017 10:38:14 GMT

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

Chanty4u — Thu, 02 Feb 2017 10:07:31 GMT

or else try with

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