Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Issue with Dates


Hi

Can anybody please help, i need to calculate the difference between the 2 dates.

Some of the rows are not getting recognized that are left or centre aligned. Tried various possible combinations using Date# , Date and Alt functions but it still wouldnt work

Attaching the dates details

6 Replies
alexandros17
Partner - Champion III
Partner - Champion III

A workaround could be:

1) read all the dates as text (Text(mydate) during loading)

2) split the date (with left, right and mid function) in dd, mm, yyyy

3) use makedate() function to obtain a date

let me know

Anonymous
Not applicable
Author

i have loaded the dates as text and it appears numeric values starting with 4.

How do i split this values?

alexandros17
Partner - Champion III
Partner - Champion III

In this case dates are recognised as Dated, try this when you load:

Text(Date(mydate))

Anonymous
Not applicable
Author

Also when i load it as text the ones that are left aligned do not get converted into text

alexandros17
Partner - Champion III
Partner - Champion III

send me your document please

Anonymous
Not applicable
Author

Hi Alessandro

There was a problem with the source data.I had to correct the way it was being exported. The query works fine now

And i am able to calculate the networdays ()

Thanks for your assistance anyways