I'm trying to make it so that my List page initially only displays records with start dates in current month and future unless the user does an advanced search or "Show All". The sql code I'm using is limiting it to only records starting in the current month until the end of the year. I'm not able to see records for January 2013 unless I do a "Show All". What am I doing wrong?
if REQUEST("a")<>"search" and REQUEST("a")<>"advsearch" and REQUEST("a")<>"showall" then
strWhereClause = whereAdd(strWhereClause,"Year(Table.StartDate) >=Year(Now()) And Month(Table.StartDate) >=Month(Now())")
end if
Thank you