Re: Get the last 12 months transactions?

[Art Broussard]

Try this

<cfquery name="transactions" datasource="whatever">
select *
from table
where date > #DateAdd("m", -12, Now())#
</cfquery>


> Does anyone know how to test that a date is in the last 12 months?
>
____________________________________________________________________________
_________
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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