RE: Get the last 12 months transactions?

[Lee Fuller]

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