#createODBCDateTime(now())# Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division
-----Original Message----- From: Frank Mamone [mailto:[EMAIL PROTECTED]] Sent: Monday, January 27, 2003 12:16 PM To: CF-Talk Subject: Date question What is the nest way to format a date to compare to a database datetime column. Basically I want to pull all records created after the original request was made. So, <CFSET RequestTime = "this is what I need"> <CFQUERY.....> SELECT ...... Where datecolumn >= RequestTime </CFQUERY> I'm really bad with date stuff and I need to learn how to work with them. Thanks, Frank ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4