i ended up just putting a check to see if the date value is less than the minimum value.
my question though, is why does the IsDate function return a True value, but SQL does not?
I am building an import program that reads a text file and inserts it into a SQL table.
One of the fields is a date. So I am doing an IsDate check on every record before it inserts. For some reason "0001-01-01" returns true on the isdate function but when it goes to the stored procedure to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.