Thanks Greg that works like a charm! B
-----Original Message----- From: Greg Morphis [mailto:[email protected]] Sent: Thursday, September 22, 2011 10:01 AM To: cf-newbie Subject: Re: date functions Use the date_add() function.. pass the date column and an interval of -30 days select date_add(dateAdded, INTERVAL -30 DAY) as myDate from my_table On Thu, Sep 22, 2011 at 8:49 AM, Andrew Scott <[email protected]>wrote: > > What is the database? > > You could use the database know functions or you could use something like > this. > > <cfset pastDate = dateAdd('day', -30, now()); > > And then do a between that date and now in the query. > > -- > Regards, > Andrew Scott > WebSite: http://www.andyscott.id.au/ > Google+: http://plus.google.com/108193156965451149543 > > > > On Thu, Sep 22, 2011 at 11:41 PM, Imperial, Bob <[email protected] > >wrote: > > > > > 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:5610 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
