Michael_Dray

Many thanks for the quick reply. The dates will always be in the same format so for example the first results will always be: By 'persons name' on 'date part' The next By 'persons name' - 'date part' If the formats are the same is there a way I could use that to strip the Unrequired parts out before using your previously stated method to convert the date? Many thanks again

Hi guys, I have a selection on sentences that I have stored as strings. They all contain dates in different formats. e.g. "By Himanshu Singh on 30 July 2014" "By Marc Shoffman - November 26th 2013, 3:47:09 pm" "Tue Sep 23, 2014 6:33pm BST" Is there a way to extract just the date from this and turn it into a standard format. For example dd/mm/yyyy Many Thanks for any help Mike