All, Has anyone ever successfully created a collection, indexed it and then searched on just a ODBC date value or in other words a date data type with an ODBC value in the record? Is there some special way/rule that needs to be applied? I'm a little lost on this. No matter what string I use to search on this ODBC date values, the search returns no results.
I've tried converting the date datatype to a varchar and hard code the date format and then search by that without any success. I'm trying to setup the search functionality to be able to search by month regardless or year, "01" or "January" and/or by year with various formats, "02" or "2002". Any comments on your successful search code writing would be so muchly appreciated. D ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:248265 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
