quote:

---

Originally posted by ruirib

Ok, I removed the second one, since the first is the one I think works as expected.

Gaurav, I think using T_LAST_POST can be misleading. Imagine a topic 4 months old, that somewhere in its contents has the keyword being searched for. Now imagine that after these four months you have a reply to it, where the keyword is not used. If you search for posts with the keyword, say for the last seven days, a day or two after this last reply has been made, the topic will appear in the result set even if the reply that complies with the time criteria does not have the keyword being searched for. So, IMO, this would lead to the topic erroneously being included in the result set.
Using T_DATE or R_DATE you are indeed ensuring that you have a post that contains the keyword and complies with the date requirements.

---

SearchLink = "&SearchTerms=" & chkString(strKeyWords,"search")
if cLng(Request.Form("SearchDate")) <> 0 then	
	dt = cLng(Request.Form("SearchDate"))
SearchLink = SearchLink & "&SearchDate=" & DateToStr(dateadd("d", -dt, strForumTimeAdjust))
end if

strSql3 = strSql3 & " AND ((T.T_DATE > '" & DateToStr(dateadd("d", -dt, strForumTimeAdjust)) & "')"
strSql3 = strSql3 & " OR (R.R_DATE > '" & DateToStr(dateadd("d", -dt, strForumTimeAdjust)) & "')"
strSql3 = strSql3 & " OR (R.R_LAST_EDIT > '" & DateToStr(dateadd("d", -dt, strForumTimeAdjust)) & "'))"

if Request.QueryString("SearchDate") <> "" then 
   strSql3 = strSql3 & "AND (R.R_DATE > '" & Request.QueryString("SearchDate") & "') "
end if
   strSql4 = "ORDER BY R.R_DATE ASC"