How can I fix this? I had used a formula years back but can't remmeber how it
goes. Thanks

=DATE(right(A1,2),mid(a1,5,2),left(A1,4))

but it does not work.

Thanks