RE: Get the last 12 months transactions?

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 Fus

Re: Get the last 12 months transactions?

ubject: Get the last 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 Arch

Re: Get the last 12 months transactions?

rsday, November 30, 2000 9:59 AM 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 Ex

RE: Get the last 12 months transactions?

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?

Something like -- Billy Cravens [EMAIL PROTECTED] fr me wrote: > > 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?

; <[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 in the last 12 months? > _ > Get more from th

RE: Get the last 12 months transactions?

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?

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?

> -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? > &

RE: Get the last 12 months transactions?

line) > www.figleaf.com > -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

RE: Get the last 12 months transactions?

, 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?

Try this select * from table where date > #DateAdd("m", -12, Now())# > Does anyone know how to test that a date is in the last 12 months? > _ > ~~ Structure you

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://explorer.msn.com ~~ Structure your C