converts the proper date

[prabhas277]

Hi ,

i have one date field in my excel ..in that the format of date field data is DD/MM/YYYY.

but if i load the data into qv then i am getting the data like string

please find the below file

how to convert the numbers to date ?

[Anil_Babu_Samineni]

while you are loading into Qlik from Data source of excel it converts to Number format only

You can use Simple

Load Date([Purchase Date],'DD/MM/YYYY') as [Purchase Date] From <Source>;

[muthukumar77]

Hi,

Date(Floor(Date),'DD/MM/YYYY')