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 CustomerRefer = #Affiliate_ID#AND
CustomerEnrollmentDate between '#DateAdd('d',-7,createODBCDate(now()))#' and
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
Well all my reference books are at work and
as it is firday night and im on my way out the door to go party just taking a
quick glance at it but (and I may just be missing a piece of the puzzle here)
but since you are selecting out CustomerEnrollementDate in the query don't you
have to