Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Kohli
Creator II
Creator II

Change the date format

I have date field like 

Date

200507

210507

310507

100308

250508

I want convert into date format like 

20-05-2007

25-05-2007

Labels (1)
3 Replies
shiveshsingh
Master
Master

Hi

 

Try this

 

=DATE(date#(200507,'DDMMYY'),'DD-MM-YYYY')

jobsonkjoseph
Creator III
Creator III

Hi, Small correction to the response, try =DATE(date#(Date,'DDMMYY'),'DD-MM-YYYY')
sasis551
Contributor III
Contributor III

Hi ,

Date#-interpretation function

Date-Formatting function

=DATE(date#(Date,'DDMMYY'),'DD-MM-YYYY')