Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
kgordish
Contributor II
Contributor II

Change String to Date (DD-MMM-YY)

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. 

 

1 Solution

Accepted Solutions
dazerano
Partner - Contributor II
Partner - Contributor II

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

View solution in original post

2 Replies
dazerano
Partner - Contributor II
Partner - Contributor II

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
Contributor II
Contributor II
Author

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

Thanks.