You may need to use the CreateDateTime() or the CreateODBCDateTime()
functions to convert the user entered dates to date time objects. Also,
enclose the form values in single quotes (').
-----Original Message-----
From: Nathan Chen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 09, 2000 10:37 AM
To: cftalk
Subject: SQL syntax: between
Hi, Everyone,
I have a query using "between" to retrieve data. The query is something
like this:
select * from mytable where mydate between #form.start_date# and
#form.end_date#
The field "mydate" is a date/time field, and #form.start_date# and
#form.end_date# are user-entered variable dates. If the user enters
"05/01/2000" and "05/09/2000", the query will exclude data on 05/01 and
the data on 05/09 because "mydate" is a date/time field. I know this
problem can be solved if I change "mydate" to date field only. If I
want to keep "mydate" as date/time field, is there a way to include
data fallen on #form.start_date# and #form.end_date#?
Any idea? Thanks in advance.
--
Nathan Chen
(208)-426-8470
Computer Control Systems, Inc.
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
