Good idea, but those are the only two records in the table! I'm just working up the "proof-of-concept" at this point, preparing to implement the full functionality.
Just can't understand why both queries return the same value... -----Original Message----- From: Bryan Stevenson [mailto:br...@electricedgesystems.com] Sent: Friday, November 05, 2010 6:49 PM To: cf-talk Subject: RE: I think I'm just making this way too hard... Without knowing what the other records in the table may be like I'd have to say there are many records that would contain a date with a day of 4 or 5. IN other words, 4 doesn't just match yesterday, it also matches the 4th day of any month. So if you have older records, that could be skewing the results. Other than that your logic seems sounds....but we don't really have the whole picture... I can say TGIF!! You can take a breather soon Rick!! ;-) Cheers ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338883 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm