RE: greater than date query ?

2006-01-05 Thread Adkins, Randy
(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

RE: greater than date query ?

2006-01-05 Thread Bobby Hartsfield
Have you tried either of these? Where (register_date = #createodbcdate('10/1/2005')#) Or Where (register_date = #createodbcdatetime('10/1/2005')#) ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Tim Laureska

RE: greater than date query ?

2006-01-05 Thread Tim Laureska
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