Hi folks, My brain is slow to grasp how to pull records from a database to get only the last 30 days. I have a scheduled task that currently grabs everything but I have a request to only include the last 30 days in the report that is generated. Running MySQL and CF9. I've tried running the following using the query tool in mysql but it returns an error: SELECT * FROM myTable WHERE dateAdded BETWEEN CURDATE() AND DATE_SUB(CURDATE)(), INTERVAL 30 DAY)
In need of enlightenment here. TIA Bob ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:5607 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
