topic converts the proper date in QlikView

converts the proper date

prabhas277 — Wed, 25 Nov 2020 16:16:04 GMT

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 — Mon, 06 Mar 2017 06:53:43 GMT

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 — Mon, 06 Mar 2017 09:42:11 GMT

Hi,

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