Issue with Dates

[Anonymous]

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

[alexandros17]

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]

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

How do i split this values?

[alexandros17]

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

Text(Date(mydate))

[Anonymous]

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

[alexandros17]

send me your document please

[Anonymous]

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