Hello,
I am having some troubles and was hoping for some help.
I have created links to DB2 tables using DB2 Connect
I have multiple queries that I run each day and I need to provide them
with a date to use in the query. I am trying to set up a textbox on
my main form that I will enter the date into and then use that in the
queries.
I use [Forms]![frmMain]![Text1] as my criteria in my query.
When I enter a date 09/09/2003 and run the query I get the following
error:
" OBDC - Call Failed
[IBM][CLI Driver][DB2]SQL0181N The string representation of a datetime
value is out of range SQLSTATE= 22007 (#-181) "
I have tried changing the properties of my textbox with no success. I
have tried short date, general number and the default (string?). None
of them seem to work.
If I type #09/08/2003# in the query criteria everything works fine.
thanks for any help you can give
I am having some troubles and was hoping for some help.
I have created links to DB2 tables using DB2 Connect
I have multiple queries that I run each day and I need to provide them
with a date to use in the query. I am trying to set up a textbox on
my main form that I will enter the date into and then use that in the
queries.
I use [Forms]![frmMain]![Text1] as my criteria in my query.
When I enter a date 09/09/2003 and run the query I get the following
error:
" OBDC - Call Failed
[IBM][CLI Driver][DB2]SQL0181N The string representation of a datetime
value is out of range SQLSTATE= 22007 (#-181) "
I have tried changing the properties of my textbox with no success. I
have tried short date, general number and the default (string?). None
of them seem to work.
If I type #09/08/2003# in the query criteria everything works fine.
thanks for any help you can give