informix date issue

[Heer]

We have an informix source that is throwing this error -> invalid month in date

I tried setting the DBDATE to MDY4/ via SETNET32 on the server but this error remains

workflow is using a dynamic input tool

how to resolve this?

[Qiu · Accepted solution]

@Heer 

I dont know about the InforMix so wild guess only.
Alteryx date format is yyyy-mm-dd and other formats will be considered as illegal format.

Maybe we can read in the data first and convert it to Date Format?