Multiple date formats

Hello,

I have two formats of date ( dd.mm.yy and dd.mm.yyyy )in my source data. How can I convert them to single date format (dd.mm.yyyy). Also, need to convert the datatype from string to date.