Failed to parse date in row (string to date) but only for 'Sep'

Hi guys,

I’ve got a strange issue with conversion of string into date. The issue seems to occur only for the month of ‘Sep’.

The data to be converted to date is shown below.

This is the dialog for conversion.

Error message.

All dates are able to be converted apart from dates that include ‘Sep’.

Any tips are appreciated.

Cheers,

Michael