Date formatting in load script

[schmidtkm37]

Hello,

I'm having an issue formatting a date field coming in from a CSV file. The field is formatted like:

8/9/2020 0:00:00

8/10/2020 0:00:00

10/10/2019 0:00:00

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"? 

[schmidtkm37 · Accepted solution]

Never mind, I got it. I just used left(field,len(field)-8) to trim the right side off and then I was able to use date() to make it a date. 

[Taoufiq_Zarra]

@schmidtkm37 

Maye be :

Date#(subfield(F1,' ',1),'M/D/YYYY') as New_date

output :