Discussion Board for collaboration related to Qlik Education.
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
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
i have loaded the dates as text and it appears numeric values starting with 4.
How do i split this values?
In this case dates are recognised as Dated, try this when you load:
Also when i load it as text the ones that are left aligned do not get converted into text
send me your document please
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