Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

sanjyotpatkar
Contributor II

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

Re: Issue with Dates

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

sanjyotpatkar
Contributor II

Re: Issue with Dates

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

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

Text(Date(mydate))

sanjyotpatkar
Contributor II

Re: Issue with Dates

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

Re: Issue with Dates

send me your document please

sanjyotpatkar
Contributor II

Re: Issue with Dates

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

Community Browser