This worked...
select * from request where closed between #CreateODBCDate(date1)# and
#CreateODBCDate(date2)#
order by closed
I think the error was because the dates I entered were not in a valid date
format, and the I was getting a conversion error trying to convert it. The
database was pro
Ok it looks like you are giving Access two strings insted of two dates. Im
assuming the field is of type date so either toss # signs around your dates
or use the DATEPART function.
A.
- Original Message -
From: "Chris Holdman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, Februa
How is the column closed defined in the database? date or datetime? What
dbms are you using? I believe some dbms won't let you compare date to
datetime.
-Original Message-
From: Chris Holdman [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 10, 2003 11:35 AM
To: '[EMAIL PROTECTED]'
Su
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 processing an element with a general identifier of
(CFQUERY), occupying document position (3:1) to (3:40).
Christopher
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 this should be easy but I am n
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]
Here are a few of today's big announcements from Macromedia:
Freehand MX is now available
Macromedia Studio MX is being renamed to Macromedia Studio MX Plus and will
now include Freehand MX, Contribute, and parts (or all?) of DRK 1 & 2
Macromedia DevNet Subscriptions in both Essentials (DRKs) a