topic Re: Issue with Dates in Qlik Learning Discussions

Issue with Dates

Anonymous — Thu, 08 Jan 2015 07:59:05 GMT

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

Re: Issue with Dates

alexandros17 — Thu, 08 Jan 2015 08:03:35 GMT

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

Re: Issue with Dates

Anonymous — Thu, 08 Jan 2015 08:23:29 GMT

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

How do i split this values?

Re: Issue with Dates

alexandros17 — Thu, 08 Jan 2015 08:27:40 GMT

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

Text(Date(mydate))

Re: Issue with Dates

Anonymous — Thu, 08 Jan 2015 08:29:05 GMT

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

Re: Issue with Dates

alexandros17 — Thu, 08 Jan 2015 08:39:13 GMT

send me your document please

Re: Issue with Dates

Anonymous — Fri, 23 Jan 2015 10:10:50 GMT

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