> -----Original Message----- > From: freeee meeeee [mailto:[EMAIL PROTECTED]] > Sent: Thursday, November 30, 2000 10:59 AM > To: CF-Talk > Subject: Get the last 12 months transactions? > > > Does anyone know how to test that a date is in the last 12 months? > > > Try something like this: SELECT fields FROM table WHERE date <= #DateAdd("m", 12, Now())# HTH, Duane Boudreau Director of Web Technologies Ektron, Inc. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ 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
