I have blogged about searching on just date and just time... If you are interested:
Only time: http://www.bennadel.com/index.cfm?dax=blog:129.view Only date: http://www.bennadel.com/index.cfm?dax=blog:122.view Averaging date and times: http://www.bennadel.com/index.cfm?dax=blog:175.view Hope that helps. ....................... Ben Nadel www.bennadel.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, July 31, 2006 7:16 PM To: CF-Talk Subject: How 2 Search on date values Does anyone know how to search on odbc date values? I really need help. I've searched all over the internet and Adobe.com and found nothing Does Verity let you search on date values from a column in a db? Should the date values be stored in separate columns, month, day and year? Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248398 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4