In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Convert String To Date

SuLewis
5 - Atom

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

2 REPLIES 2
JosephSerpis
17 - Castor
17 - Castor

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

 

Dates_21072020.JPG

SuLewis
5 - Atom

Thank you - this worked and now makes sense

Labels
Top Solution Authors