Thanks, everyone, for the feedback. I *finally* got this stupid (that's the headache talking) query working. Seems like working with comparing dates in queries has always been a chore. Mostly because I do it rarely.
And, everyone was right, I did have MySQL working on the part that CF should have been processing. I did mention in an earlier post that it was MySQL 5. Anyway, here's what finally worked: select totalNew from 04a_dailyNumberNewHMLSProperties where day(date_add(dateOfTotal, interval -1 day)) = #dateFormat(dateAdd('d', -1, now()), 'd')# Now I can rest in peace. (or pieces if my headache does finally split my head) Have a good evening everyone! Rick -----Original Message----- From: Bryan Stevenson [mailto:br...@electricedgesystems.com] Sent: Friday, November 05, 2010 4:50 PM To: cf-talk Subject: RE: I think I'm just making this way too hard... Apologies Rick....I now see that dateOfTotal is the new column name. You have it backwards....you are using the DB function (date_add()) on now() and should be using dateAdd() (CF function)....likewise...where you are using dateAdd() you should be using date_add(). Cheers 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:338872 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm