Date conversions

[hopkinsc]

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

[sergio0592 · Accepted solution]

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'))

[hopkinsc]

fantastic, thanks very much.