hello all,

i have a file that i get from a database that has multiple date fields and each date is in a different format for example one format is

20180601 which translates to 01.06.2018
and another format is
27/12/20170 with an extra "0" at the end of the year

is there a formula or something that can change those into DD/MM/YYYY format ?

thanks in advance