Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
hopkinsc
Partner
Partner

Date conversions

Hi all,

i have a date field in the format of DMMYY but i need to format it to DD/MM/YYYY, can anyone help please?

i have attached a sample

1 Solution

Accepted Solutions
sergio0592
Specialist III
Specialist III

Hi,

In your sample you have two formats with DMMYY (10116) and DDMMYY (120116). So for manage these différences you can use :

=if(len(Date_field)=5,Date(Date#(Date_field,'DMMYY'),'DD/MM/YYYY'),Date(Date#(Date_field,'DDMMYY'),'DD/MM/YYYY'))

View solution in original post

2 Replies
sergio0592
Specialist III
Specialist III

Hi,

In your sample you have two formats with DMMYY (10116) and DDMMYY (120116). So for manage these différences you can use :

=if(len(Date_field)=5,Date(Date#(Date_field,'DMMYY'),'DD/MM/YYYY'),Date(Date#(Date_field,'DDMMYY'),'DD/MM/YYYY'))

View solution in original post

hopkinsc
Partner
Partner
Author

fantastic, thanks very much.