How to recognize a date from .csv export

[d_petrov]

Hello,

I Have dates, which are coming from a .csv file  in the following format:

Aug 14, 2018 6:30 AM

Aug 30, 2018 6:30 AM

I am trying to get the working days between these two dates by using the NetWorkDays function, but seems like these values are not recognizable in qlikview as a real dates. Applying Month(),  Year() , or Day() always  returns  '-'.
Tried also with Date  and format string 'M/D/YYYY', I even tried with Date(Date#([value],'MM/DD/YYYY'), 'MM/DD/YYYY') , unfortunately I always got the same '-'.
Is there any way to recognize these values as dates and get working days difference between them?

Regards,
D. Petrov

[sunny_talwar · Accepted solution]

Try this

Date(Floor(Date#([value],'MMM DD, YYYY hh:mm TT')), 'MM/DD/YYYY')

[d_petrov]

It work, thank you very much!

Kind Regards,

D. Petrov