Format Date

[upaliwije]

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

[#2 · Accepted solution]

See attacched qvw.

regards.
MC

[#3]

just change it to

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

[Anonymous]

just using works for me -

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

[jerem1234]

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]

Thanks all  for prompt reply