Converting date format

[mkhwanazi]

Greetings everyone,

I am new to Qlik Sense and I am looking for a way to convert date from 'YYYY/MM/DD' format to 'YYYY-MM-DD' using Data Load Editor. Can anyone kindly assist.

Cheers,

[hector · Accepted solution]

Hi
should be date(date#(field,'YYYY/MM/DD'),'YYYY-MM-DD')
regards