2 Replies Latest reply: Jul 9, 2015 6:42 PM by Drew Timberlake RSS

    Invalid date, time or timestamp value

      I am having an issue loading data when I include a field that contains dates.  I've played around with a WHERE .... BETWEEN statement and found that this fails:

      Capture4.PNG

      Capture3.PNG

      But this works:

      Capture5.PNG

       

      2 questions....

       

      1. Any thoughts on how why this is failing?  There are no dates between 4-30-2000 and 5-1-2000 so logically they should both work or both fail.

       

      2. Is there a way to have the load script skip any entries where there is an "invalid date, time or timestamp value" so in the future I wouldn't have to figure what dates are breaking the query?