Thanks, that was exactly what i needed. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bakken, Kory Sent: Tuesday, March 19, 2002 9:39 AM To: '[EMAIL PROTECTED]' Subject: RE: [KCFusion] Date Query
You have to change the date into a date that SQL can use in compare statements like such... <cfset CompareDate = CreateODBCDate(Date)> <cfquery...> ... WHERE inspDate > #CompareDate# </cfquery> -----Original Message----- From: James K Tieman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 19, 2002 9:04 AM To: KCFusion Subject: [KCFusion] Date Query How do I do write this where clause to a Date/Time field in Access2000? WHERE inspDate > 01/31/2002 Jamie ______________________________________________________________________ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives........ http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe.................... mailto:[EMAIL PROTECTED] To Unsubscribe................ mailto:[EMAIL PROTECTED] ______________________________________________________________________ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives........ http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe.................... mailto:[EMAIL PROTECTED] To Unsubscribe................ mailto:[EMAIL PROTECTED] ______________________________________________________________________ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives........ http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe.................... mailto:[EMAIL PROTECTED] To Unsubscribe................ mailto:[EMAIL PROTECTED]