Re: Get the last 12 months transactions?

2000-12-01 Thread Daryl Fullerton
12 months transactions? 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

RE: Get the last 12 months transactions?

2000-12-01 Thread 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 last 12 months transactions?

2000-11-30 Thread freeee meeeee
Does anyone know how to test that a date is in the last 12 months? _ Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com ~~ Structure your

Re: Get the last 12 months transactions?

2000-11-30 Thread 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? _

RE: Get the last 12 months transactions?

2000-11-30 Thread Brandon Behrens
, 2000 9: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? _ Get more from the Web. FREE MSN Explorer download : http

RE: Get the last 12 months transactions?

2000-11-30 Thread Simon Horwith
nt: 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? _ Get more from the Web. FREE MSN Exp

RE: Get the last 12 months transactions?

2000-11-30 Thread Duane Boudreau
-Original Message- From: fr me [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

RE: Get the last 12 months transactions?

2000-11-30 Thread Dylan Bromby
You can use DateDiff() -Original Message- From: fr me [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 30, 2000 7: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

RE: Get the last 12 months transactions?

2000-11-30 Thread Dylan Bromby
Or if you want to do it in SQL, use the BETWEEN operator -Original Message- From: fr me [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 30, 2000 7: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

Re: Get the last 12 months transactions?

2000-11-30 Thread Gregory Harris
r me" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, November 30, 2000 7:59 AM Subject: Get the last 12 months transactions? Does anyone know how to test that a date is i

Re: Get the last 12 months transactions?

2000-11-30 Thread Billy Cravens
Something like cfif (DateDiff("m",Now(),MyDate) LT) 0 AND (DateDiff("m",Now(),MyDate) GT -12) -- Billy Cravens [EMAIL PROTECTED] fr me wrote: Does anyone know how to test that a date is in the last 12 months?

RE: Get the last 12 months transactions?

2000-11-30 Thread Rick Lamb
Check out the function dateDiff() -Original Message- From: fr me [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 30, 2000 9: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

Re: Get the last 12 months transactions?

2000-11-30 Thread Kevin Schmidt
- From: "fr me" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, November 30, 2000 9:59 AM Subject: Get the last 12 months transactions? Does anyone know how to test that a date is i