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
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.
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
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?
_
, 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
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
-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
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
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
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
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?
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
-
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
13 matches
Mail list logo