Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Unrecognised date format - expected separator missing

PiersM
7 - Meteor

Hi, I'm pretty new to Alteryx so apologies if this is an obvious one -

 

I am importing a csv where the date format is 'yyyymm' - an unrecognised format. I have tried using the DateTime tool but I get the following error 'DateTime_Out: Cannot convert "201801" to a date/time with format "%Y-%M': Expected separator '-%M', got: '01'Record#'

 

I also tried using the DateTimeParse expression in the Formula tool and get a similar error referencing the Expected separator.

 

How can I introduce a separator to solve this problem?

2 REPLIES 2
fmvizcaino
17 - Castor
17 - Castor

Hi @PiersM ,

 

In DateTime tool, when changing string to date format, you need to select the string format and Alteryx will automatically convert to the standard Alteryx date format.

 

Example attached.

Best,

Fernando Vizcaino

PiersM
7 - Meteor

Hi Fernando - 

 

Apologies for my first reply - I tried your solution again and it works...thanks!

Piers

Labels