Changing year format from two digit to four digit [Closed]

Report
-
Hello,

I have data in three columns containing dates that have two formats; some display as dd/mm/yy and others display as dd/mm/yyyy. I need the four digit year, but nothing I've tried changes the existing data from 2 digit years to four digit years. Any ideas on how to correct this?

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!