Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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'))
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'))
fantastic, thanks very much.