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 [mailto:[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 to use for the 10/1/2005
The access date field is in the Date/Time format
Thanks
Tim
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228509
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
