Dates from Excel

[tomgrouwe]

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.

[arpitkharkia]

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.

[tomgrouwe]

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...

[arpitkharkia]

Thats right, can you share the excel file?

[tomgrouwe]

Here you go.

[arpitkharkia · Accepted solution]

Showing up correct for me.

[tomgrouwe]

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

[arpitkharkia]

Cool