Change String to Date (DD-MMM-YY)

[kgordish]

Hello,
Recently new to Qlik. 
I had to make a compromise in export data from Alteryx. In order to cells with nulls have text I have Alteryx exporting a column as string data. I needed to easily search the null values in Qlik.

Goal change string to date data in Qlik.
My current dimension is "Due Date" 

Current format "Due Date" YYYY-MM-DD (String)
Desired format "Due Date" DD-MMM-YY (Date)

Can some recommend an expression or script in the ETL screen?

Appreciate the assistance.  Thank you kindly. 

[dazerano · Accepted solution]

First used Date#() to interpret  the string as a date. Then use date for the desired format.

DATE(  DATE#(  [Due Date] , 'YYYY-MM-DD'), 'DD-MMM-YY')

[kgordish]

Thank you. I will add this knowledge to my tool kit. 
Helpful to see code language written with your variable. 

Thanks.