Have an issue with what I believe is a corrupted date value. It resides in purchase order detail required date and PO header PO date.
Running the open order report on "required expire date" for date greater than 12/30 will result in "Vendor Code 9" database error. Running a similar query in the ODBC in excel results in:
[Providex][ODBC Driver][FILEIO]Invalid Date Contents
Now, if you break the query into a range between 12/30/2015 and 12/31/2015 and another one for greater than 1/1/2016 information will return. So I suspect that there is a date somewhere with a garbled day in december, but I'm not sure, or how to locate it if this is actually the case.
Anyone seen anything like this?
Thanks in advance!