,createODBCDate(now()))#'
-Original Message-From: Robert
[mailto:[EMAIL PROTECTED]Sent: Friday, August 01, 2003 11:03
PMTo: [EMAIL PROTECTED]Subject: [KCFusion] DateDiff
in SQL Query
I am running into a problem and I can't figure
out why. I know i've had this problem before
To: [EMAIL PROTECTED]
Sent: Monday, August 04, 2003 8:10
AM
Subject: RE: [KCFusion] DateDiff in SQL
Query
You cannot treat
CustomerEnrollmentDateas a CF Variable until you are
outside of that query. The following where clause should get you what
you need:
WHERE
I am running into a problem and I can't figure out
why. I know i've had this problem before with using CF functions inside of
SQL queries, but I can never remember what it was the last time that fixed it,
so I wanted to post this query:
CFQUERY name="getcustomers"
DATASOURCE="x"SELECT
to assign it a value before you use it in the DateDiff function, or did you
already do that and it does not show up in your snippet?A.
- Original Message -
From:
Robert
To: [EMAIL PROTECTED]
Sent: Friday, August 01, 2003 11:02
PM
Subject: [KCFusion] DateDiff in SQL
Query