Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: MOD Implementation
 Member Filter Mod		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

goju
New Member

Canada
67 Posts
Posted - 21 December 2002 :  14:13:07  Show Profile  Visit goju's Homepage
How would I change this part (and i guess any others if neccessary) so that this filter shows new members for the week and not just that day?

elseif varFilter = "New" then
strListTitle = "New Members"
strNoRecordsMsg = "No New Members Today"
strSql3 = strSql3 & " AND M_DATE >='" & DateToStr(DateValue(strForumTimeAdjust)) & "'"

GauravBhabu
Advanced Member

4288 Posts
Posted - 21 December 2002 :  14:40:55  Show Profile
Why you use DateValue(strForumTimeAdjust)?

To show new members during last seven days use this

strSql3 = strSql3 & " AND M_DATE >='" & DateToStr(DateAdd("d", -7, Date()))
Go to Top of Page

goju
New Member

Canada
67 Posts
Posted - 22 December 2002 :  10:50:10  Show Profile  Visit goju's Homepage
Awesome I think it works, just need to keep the & "'" at the end.
Go to Top of Page

GauravBhabu
Advanced Member

4288 Posts
Posted - 22 December 2002 :  13:17:12  Show Profile
quote:
Originally posted by goju

Awesome I think it works, just need to keep the & "'" at the end.

Yes!
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.35 seconds. Powered By: Snitz Forums 2000 Version 3.4.07