Conversion error: not a valid date

[Ronal_bal]

Hi,

When i try to pull the data in using the input tool i receive conversion error attached the screenshot

Upon searching, i came to know Alteryx doesn't consider 0001-01-01 has a valid date.

Can someone help me with workaround to remove the conversion error?

[Luke_C]

Hi @Ronal_bal 

The workaround would probably be setting it to some other date such as 1900-01-01 or 2099-12-31. My assumption is this data is set-up as a placeholder until an actual date is entered? Does it drive any logic for you? 

[Ronal_bal]

Yes, Can you share how'd do that?

[Ronal_bal]

@Luke_C 

[Luke_C]

Hi @Ronal_bal 

It depends, what's your input? If it's reading from a database I assume the conversion error is nulling out those records? The quick way would probably be something like

if isnull([dt_exp_effective])

then '2099-01-01'

else [dt_exp_effective]

endif

[Ronal_bal]

@Luke_C I'm receiving the error at the input tool

[Ronal_bal]

@Luke_C Just to re-iterate my need here, I need to remove those conversion errors from the input tool. Thanks for the help!

[Luke_C]

Hi @Ronal_bal 

What is the source of data? These are just warnings, not errors which is an important clarification, depending on what the input source is you may or may not be able to resolve at the source, but can handle the warnings in the workflow.