Dateadd

Can any help me? I have a problem with this DATEADD function, its supposed to pull out entries for the next week. Can anyone spot what I'm doing wrong

" WHERE (tblContactLog.CallBackEmployee_id = " & Session("UserID") & ")" & _
" AND (tblContactLog.ContactLog_Complete <> 1)" & _
" AND (tblContactLog.ContactLog_CallBackDate < DATEADD(ww, 1, ContactLog_CallBackDate))" & _

two things

first, you end with a concatenation (is there more to this query?)

second, you are testing

... AND (X < DATEADD(ww, 1, X))

which will find any date that is less than a week after itself??? i.e. none

Thanks for your help. Heres the full code, all I want to do is pull out entries for the next week for that user. Its basically a contact log. Any ideas!


set rs = objConn.execute("SELECT tblContactLog.*, tblContactLogType.ContactLogType_desc, " & _
" tblLeads.name, tblLeads.surname, tblLeads.lead_id, tblInternalEmployees.fullname" & _
" FROM tblContactLog" & _
" INNER JOIN tblContactLogType ON tblContactLog.ContactLogType_id = tblContactLogType.ContactLogType_id" & _
" INNER JOIN tblLeads ON tblContactLog.lead_id = tblLeads.lead_id" & _
" INNER JOIN tblInternalEmployees ON tblContactLog.InternalEmployee_id = tblInternalEmployees.user_id" & _
" WHERE (tblContactLog.CallBackEmployee_id = " & Session("UserID") & ")" & _
" AND (tblContactLog.ContactLog_Complete <> 1)" & _
" AND (tblContactLog.ContactLog_CallBackDate < DATEADD(ww, 1, ContactLog_CallBackDate))" & _
" ORDER BY " & _
" CASE " & _
" WHEN tblContactLog.ContactLog_Priority=1 THEN 0 " & _
" ELSE 1 " & _
" END, tblContactLog.ContactLog_CallBackDate ASC")

you are still doing the impossible:
no matter what value ContactLog_CallBackDate has, it will never be less than one week later than itself

you might try
but you will likely want something for the lower bound as well, since this would pull all rows from history as well