Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

d_petrov
New Contributor III

How to recognize a date from .csv export

Hello,

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

Aug 14, 2018 6:30 AMAug 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

1 Solution

Accepted Solutions

Re: How to recognize a date from .csv export

Try this

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

Re: How to recognize a date from .csv export

Try this

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

Re: How to recognize a date from .csv export

It work, thank you very much!

Kind Regards,

D. Petrov