Hi All,

I am trying to filter a RS by a certain date. I have declared a variable for the current month and now I need to know how to call for that variable in the SQL of my RS.

Sample code:
Declared Month Variable
<%
Dim rptmonth
rptmonth=month(date)
%>

I need to know how to call for the "rptmonth" variable in my SQL.

THANKS

Peter