topic Re: Dates from Excel in QlikView

Dates from Excel

tomgrouwe — Thu, 18 Apr 2019 09:58:07 GMT

Hi all,

Can someone help/explain the following issue.

I'm importing data from a single excel file. In the Qlikview table below you can see that in row 4 the date is displayed correct. In the other rows there is a number. I find this strange because the excel cels contain a normal short date format. In the script i'm not doing any editing with date functions.

Re: Dates from Excel

arpitkharkia — Thu, 18 Apr 2019 11:50:21 GMT

Better use the date function to make sure all your dates are in the same format.

Date(YourDateField,'DD-MM-YYYY')

I hope this helps.

Re: Dates from Excel

tomgrouwe — Thu, 18 Apr 2019 12:02:00 GMT

It works. Still, I find it strange that one date (16-4-2019) isn't in the same format as the rest of the dates...

Re: Dates from Excel

arpitkharkia — Thu, 18 Apr 2019 12:14:10 GMT

Thats right, can you share the excel file?

Re: Dates from Excel

tomgrouwe — Thu, 18 Apr 2019 14:39:22 GMT

Here you go.

Re: Dates from Excel

arpitkharkia — Thu, 18 Apr 2019 15:04:04 GMT

Showing up correct for me.

Re: Dates from Excel

tomgrouwe — Thu, 18 Apr 2019 15:09:10 GMT

Changed my doc settings from 'D-M-YYYY' to 'D-MM-YYYY'. Works fine now

Re: Dates from Excel

arpitkharkia — Thu, 18 Apr 2019 15:10:31 GMT

Cool