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?

error.png

Date Time

Data Investigation

Database Connection

Accepted answers

All comments

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?

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703