Let's assume your column name is Order Date and you want in dd-mm-yyyy format. I have assumed that dd is always 01.
01 + "-" + // This is for dd
RIGHT([Order Date], 2) // This is for mm
+ "-" +
LEFT([Order Date], 4) //This is for yyyy