Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
tomgrouwe
New Contributor III

Dates from Excel

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.


image.png

Tags (3)
1 Solution

Accepted Solutions
arpitkharkia
Contributor III

Re: Dates from Excel

Capture.PNG

 

Showing up correct for me.

View solution in original post

7 Replies
arpitkharkia
Contributor III

Re: Dates from Excel

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
New Contributor III

Re: Dates from Excel

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

afbeelding.png

arpitkharkia
Contributor III

Re: Dates from Excel

Thats right, can you share the excel file?

tomgrouwe
New Contributor III

Re: Dates from Excel

Here you go.

arpitkharkia
Contributor III

Re: Dates from Excel

Capture.PNG

 

Showing up correct for me.

View solution in original post

tomgrouwe
New Contributor III

Re: Dates from Excel

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

afbeelding.png

arpitkharkia
Contributor III

Re: Dates from Excel

Cool