topic Format Date in QlikView

Format Date

upaliwije — Wed, 19 Mar 2014 16:09:26 GMT

I attach herewith my QV file. In the Pivot table I do not get the desires result in the date_new column

. I want the date_new to be shown as 31-Mar-2014

pls help me

Wed, 19 Mar 2014 16:13:38 GMT

See attacched qvw.

regards.
MC

Wed, 19 Mar 2014 16:15:55 GMT

just change it to

Date(date,'DD-MMM-YYYY') as date_new

Anonymous — Wed, 19 Mar 2014 16:16:00 GMT

just using works for me -

Date(date,'DD-MMM-YYYY') as date_new

jerem1234 — Wed, 19 Mar 2014 16:20:26 GMT

Is this the same as Date Format?

If so, then what I had suggested already in my post should work for you:

Date(date, 'DD-MMM-YYYY')

Hope this helps!

upaliwije — Wed, 19 Mar 2014 16:20:47 GMT

Thanks all for prompt reply