Extracting Date from exported data

I have a field in an imported set of data I which I need to use in the creation of a tables which needs to selectively display information for certain date periods so having the date in a recognisable field is essential.

The field appears as: Wed Jan 21 00:00:22 CST 2015

I have tried variations of the below but can't seem to get it to pull out the date properly:

=DATEVALUE((LEFT(RIGHT(A1;18);4))&"2015")

=DATEVALUE(RIGHT(LEFT(A1;18);4))

Any assistance would be appreciated.