A reader wrote in with this question, but it's not one that our AS/400 experts could answer. So any Microsoft SQL experts out there, please chime in:
I am an SQL novice.......I am getting the following error message:
[Microsoft][ODBC SQL Server Driver][SQLServer] The conversion of a char data type to a datetime data type resulted in an out of range datetime value.
I think this is saying I am trying to enter a character data type for a datetime value, but I am not. It asks for a datetime stamp for the data which needs to be in the format of YYYYMM01 and I am entering 20080201, which is how I have entered it each month for the last 2 1/2 years. Any ideas?
April 25, 2008 3:34 PM