How to recognize a date from .csv export

d_petrov — Tue, 15 Jan 2019 14:13:29 GMT

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

Re: How to recognize a date from .csv export

sunny_talwar — Tue, 15 Jan 2019 14:20:56 GMT

Try this

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

Re: How to recognize a date from .csv export

d_petrov — Tue, 15 Jan 2019 14:36:45 GMT

It work, thank you very much!

Kind Regards,

D. Petrov

topic How to recognize a date from .csv export in QlikView

How to recognize a date from .csv export

Re: How to recognize a date from .csv export

Re: How to recognize a date from .csv export