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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
