I'm having an issue formatting a date field coming in from a CSV file. The field is formatted like:
which is causing issues because I can't just take the left 10 characters since sometimes I only need the left 8 and sometimes 9. I've tried using date() and makedate() but nothing has worked. Any suggestions on the best way to get Qlik to recognize this as a date and get it formatted to not include the "0:00:00"?