Zero date value prohibited

Hello I have a workflow in which I am selecting from a table and then have db reader to read from the table selector and I’m getting an error-zero date value prohibited. I was wondering what I should do.
image
I put this image in my JDBC connector string. Any thoughts?

1 Like

Hi @hookemhorns could be as simple as the name being spelt incorrectly?

zerodatetimebehavior is what is should read, you put zeroDateTimeBeahvior, sometimes it’s always better to copy and paste these things, not type them out.

Let me know!

Matt

2 Likes

Nice catch, can’t believe I didn’t see that when I put the screenshot up.

1 Like

@hookemhorns No problem, we all have a lot going on so very easy to overlook in the moment, I’ve done it many times. Glad to help! :+1:

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.