MOD: Most Recent Posts

HI all,

This one is for the SQL gurus...

Using this part of MM's SQL
<snip>

strSql = strSql & "ON T.Forum_ID=P.Forum_ID) "
    strSql = strSql & "ON P.Forum_ID=F.Forum_ID "
strSql = strSql & "WHERE T.Hide="& strDBFalse & " AND Th.Hide=" & strDBFalse & " AND (P.View_Forum=" & strDBTrue & " AND (P.Group_ID = " & intGroupID & " OR P.Author_ID = " & lngLoggedInUserID & ")) "

</snip>

...I have been unsuccessful at putting a date parameter to show posts on or before today ( for the last calendar year ) on the end of the strSql. My last attempt, of many, is this:

Declaration at top of page - BeginDate = YEAR(dtmNow)

strSql = strSql & "WHERE YEAR(Th.Message_date) <= BeginDate "

Can someone please explain where I am going wrong?

Kind regards

Suede

Hello MrMellie, I use this MOD and it works great, what do I need to do to customize it to pull Top xx latest posts for a particular user?