Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Dates Transformation with different formats

Hi All,

Please help for the below issue.

i have two columns with dates, one column with DD/MM/YYYY, DD-MMM-YY & DDMMYYYY format, how to convert all in one format.

Dates
29/09/2019
26-Sep-19
20092019

another column with DD/MM/YYYY, DD-MMM-YY & DDMMYYYY format, additional 'YYYYMMDD' how to convert all in one format.

Dates
29/09/2019
26-Sep-19
20092019
20190910
2 Replies
Highlighted
MVP
MVP

Re: Dates Transformation with different formats

You can use date#() and alt() in combination. One example is here : Handling multiple date formats 

Highlighted
Contributor III
Contributor III

Re: Dates Transformation with different formats

Thanks it's working...