topic Change String to Date (DD-MMM-YY) in QlikView

Change String to Date (DD-MMM-YY)

kgordish — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Change String to Date (DD-MMM-YY)

dazerano — Thu, 24 Oct 2019 13:10:16 GMT

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')

Re: Change String to Date (DD-MMM-YY)

kgordish — Thu, 24 Oct 2019 13:34:00 GMT

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

Thanks.