Wouldn't this tell you whether the date is in the NEXT 12 months... neverending 12 months, I might add? > Try something like this: > > SELECT fields > FROM table > WHERE date <= #DateAdd("m", 12, Now())# ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
- Get the last 12 months transactions? freeee meeeee
- Re: Get the last 12 months transactions? Art Broussard
- RE: Get the last 12 months transactions? Brandon Behrens
- RE: Get the last 12 months transactions? Duane Boudreau
- RE: Get the last 12 months transactions? Lee Fuller
- RE: Get the last 12 months transactions? Dylan Bromby
- RE: Get the last 12 months transactions? Dylan Bromby
- Re: Get the last 12 months transactions? Gregory Harris
- Re: Get the last 12 months transactions? Billy Cravens
- RE: Get the last 12 months transactions? Rick Lamb
- Re: Get the last 12 months transactions? Kevin Schmidt
- Re: Get the last 12 months transactions? Daryl Fullerton
- RE: Get the last 12 months transactions? Simon Horwith