time >
dateadd

add time , Search by Date,  Search by Time, Month

DateAdd("m",1,now) 
month plus +1 from now

    yyyy - Year
    q - Quarter
    m - Month
    y - Day of year
    d - Day
    w - Weekday
    ww - Week of year
    h - Hour
    n - Minute
    s - Second
similar to datediff

<%
response.write DateAdd("m",1,now)
%>
--------------------------------------------------

<%
Set rs = GetSQLserverRecordset
(conn, "select Distinct IP1 from TB1 
WHERE Time1 < ' " & DateAdd("h",-1,now) & " ' ")

%>

add one month to present time now
m:: month