sql - How to filter less than 7 days on my Query for my weekly report -

this query

select      studentid, dateregistered       studenttable       datediff(day, dateregistered, '" & date.now & "') <= 7 

you didn't tag rdbms, , every 1 has different functions dates, 1 of should work fine:

select studentid, dateregistered  studenttable  datediff(day, dateregistered, now()) <= 7 

or

    datediff(day, dateregistered, getdate()) <= 7 

or this:

curdate() 

note used local dbms select date, no need paramether on php side.