Trying to setup a where statement for an access database query.
essentially I need to modify this somehow to make it work right:
Where (register_date = 10/1/2005)
Need to know what syntax to use for the 10/1/2005
The access date field is in the Date/Time format
Thanks
Tim
(register_date = '10/1/2005')
You can also use the CFQUERYPARAM CFSQLTYPE=CF_SQL_DATE
VALUE=10/1/2005
-Original Message-
From: Tim Laureska [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 05, 2006 11:57 AM
To: CF-Talk
Subject: greater than date query ?
Trying to setup a where
:[EMAIL PROTECTED]
Sent: Thursday, January 05, 2006 11:57 AM
To: CF-Talk
Subject: greater than date query ?
Trying to setup a where statement for an access database query.
essentially I need to modify this somehow to make it work right:
Where (register_date = 10/1/2005)
Need to know what syntax
Thanks all for the reponses!
Tim
-Original Message-
From: Bobby Hartsfield [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 05, 2006 12:08 PM
To: CF-Talk
Subject: RE: greater than date query ?
Have you tried either of these?
Where (register_date = #createodbcdate('10/1/2005
4 matches
Mail list logo