Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
sujit_nath
Creator III
Creator III

Convert dates to a common format.

I have date like this:

 

Date

June-20-2018

Jun-19-09

01-12-2020

20-02-2020

 

How do I convert them in a common format? say dd-mm-yyyy.

2 Replies
jwjackso
Specialist III
Specialist III

Use the Alt() function

=Date(Alt(Num(Date#([Date],'MMM-DD-YYYY')),Num(Date#([Date],'MMM-DD-YY')),Num(Date#([Date],'MM-DD-YYYY')),Num(Date#([Date],'DD-MM-YYYY'))),'DD-MM-YYYY')

Vegar
MVP
MVP

the suggestion by @jwjackso will work in many cases, but not if your column could contain both 'MM-DD-YYYY' and 'DD-MM-YYYY' as you can by no means know you just looking at eg. 06-12-2021 identify the format. It will return a date value using any of the two patterns. It could be 12th of June or the 6th of December,  you can't tell which.