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/[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
