and to add just a bit more.... where I have now, you could easily have...
#DateFormat(Now(),'mm/dd/yyyy')# or you could have '#DateFormat(Now(),'mm/dd/yyyy')# 00:00:00.000' to signify midnight '#DateFormat(Now(),'mm/dd/yyyy')# 23:59:59.999' to signify the end of the day '#DateFormat(Now(),'mm/dd/yyyy')# 11:21:23.000' 11:21 am its really up to you, in sql server, it seems to accept most any date/time format. ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping & reporting www.navtrak.net 410.548.2337 -----Original Message----- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Monday, January 27, 2003 12:21 PM To: CF-Talk Subject: RE: Date question you can do this... <cfquery name="blah" datasource="foo"> select * from foo where TheDate >= #Now()# </cfquery> and that value can be anything that is acceptable date format ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping & reporting www.navtrak.net 410.548.2337 -----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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
