Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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.