How to change date format

[#1]

Hi,

I have data format in SQL table as 15/10/2013. so when I am loading data it is taking in the same way in qlikview chart.

Is it possible to show date as 15 Oct 2013?

Please can anyone let me know.

Thanks.

[jerem1234 · Accepted solution]

Date(Yourdate, 'DD MMM YYYY') should do it

[#3]

Thanks and it's working.

[nilesh_gangurde]

Create new Field as mentioned below:

Load

Date(DateField,'DD-MMM-YYYY') as DATE;

Select * From DatabaseTableName;

Hope this will help you.

-Nilesh