how to filter a select statement in mysql for a particular time period without using now()

how to filter a select statement in mysql for a particular time period
without using now()

i have tried to filter records but with the use of now function as given
below
select * from table where date>= DATE_SUB( NOW( ) ,INTERVAL 90 DAY )
what i need is a select statement that can filter its records for a week
or month from the current date but without using NOW() function