Thanks for the suggestion. I did use hard-coded dates, but not 4's and 5's. Next step would have been that.
However, per my latest post before this, I think we have a winner! :o) -----Original Message----- From: Bryan Stevenson [mailto:br...@electricedgesystems.com] Sent: Friday, November 05, 2010 7:15 PM To: cf-talk Subject: RE: I think I'm just making this way too hard... So much for that plan ;-) Have you tried each query with hardcoded values (i.e. stuff in the 4s and 5s where you think they should be)? If that works, then what you think you are running (when using dates and date functions) may not really be running what you think. Other than that...I'm outta ideas (and here for the day). Good luck!! Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: br...@electricedgesystems.com web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. Please consider the environment before printing this e-mail ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:338886 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm