datetimeparse error

seelan89

Hi All,

 

I'm pretty new to using Alteryx and am getting the below error messages and would appreciate if i get could get some guidance on how to fix it please.

 

I have a column with dates, this is in a "date" type. I tried to do a datetimeparse formula but got the below errors.

When i tried to run the workflow without the datetimeparse i still get the "invalid date" error.

 

 

ConvError: Formula (6): DATETIMEPARSE: Cannot convert "2018-04-30" to a date/time with format "%d/%m/%Y": Expected separator '/%m/%Y', got: '18-04-30'

 

ConvError: Input Data (29): Conversion error on record: 55 - Invalid date - Earliest date supported is Dec 30, 1899

 

Many thanks

jrgo

@seelan89,

Since you're formatting the date value to a non-supported date format, the field needs to be set to a string. So if you're trying to update an existing field to that new format, it won't work. You'll need to create a new field name setting it as one of the string types. you can then use a select tool afterwards to deselect the old one and rename the new field if needed.

Keep in mind you can no longer do any type of date functions on that value since it's no longer in the ISO format (YYYY-MM-DD).