Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Read about Qlik’s Response to COVID-19 Read the Letter, Join the Group.
New 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. 

 

Tags (2)
1 Solution

Accepted Solutions
Highlighted
Partner
Partner

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

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
Highlighted
Partner
Partner

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

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

Highlighted
New Contributor II

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

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

Thanks.