PROTECTED]
-Original Message-
From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 10, 2003 11:59 AM
To: [EMAIL PROTECTED]
Subject: Re: [KCFusion] Select in Date Range
Ok it looks like you are giving Access two strings insted of two dates. Im
assuming the field is of
CTED]>
Sent: Monday, February 10, 2003 11:43 AM
Subject: RE: [KCFusion] Select in Date Range
> I get an error
> ODBC Error Code = 22005 (Error in assignment)
> [Microsoft][ODBC Microsoft Access 97 Driver] Data type mismatch in
criteria
> expression.
> The error occurred while
PROTECTED]'
Subject: [KCFusion] Select in Date Range
Okay I know this should be easy but I am not having any success. I want to
select betwee two dates. Here is my query, what am I doing wrong.
select * from request where closed between '2002-10-01 00:00:00' AND
'2002-1
).
Christopher V. Holdman
Webmaster - City of Olathe
(913) 971-6286
(913) 238-4681 Cell
[EMAIL PROTECTED]
-Original Message-
From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 10, 2003 11:48 AM
To: [EMAIL PROTECTED]
Subject: Re: [KCFusion] Select in Date Range
What are
What are you getting when you run this? An error or an empty record set?
A.
- Original Message -
From: "Chris Holdman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 10, 2003 11:34 AM
Subject: [KCFusion] Select in Date Range
> Okay I know thi
Two thoughts, you might want to try > and <, or better yet >= and <=
instead of between.
Also, if you intend to search through 12-15, move your date to midnight 12-16.
At 11:34 AM 2/10/2003 -0600, you wrote:
Okay I know this should be easy but I am not having any success. I want to
select betwe
Okay I know this should be easy but I am not having any success. I want to
select betwee two dates. Here is my query, what am I doing wrong.
select * from request where closed between '2002-10-01 00:00:00' AND
'2002-12-15 00:00:00'
order by closed
Christopher V. Holdman
[EMAIL PROTECTED]
