Convert String To Date

[SuLewis]

I have csv files that have the date format as a string in the format of "28 Feb, 2020".  I need to convert this to a date format.  I have tried date time parse and date time format in formula but keep receiving converstion error messages.

ConvError: Formula (25): DATETIMEPARSE: Cannot convert "2 Mar, 2020" to a date/time with format "%d %month, %yyyy": Expected a number for Month: 'Mar, 2020'

Any guidance greatly appreciated

[JosephSerpis · Accepted solution]

Hi @SuLewis I mocked a workflow let me know what you think? This link should also help with the specifiers for the datetime functions.

[SuLewis]

Thank you - this worked and now makes sense