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?