SELECT user.username, offer.* FROM offer INNER JOIN user ON user.userid = offer.userid WHERE offer.date BETWEEN (NOW() - INTERVAL 40 DAY) AND NOW()
This work fine. It display record with in 40 days time interval, With current day/date as ref.
I want to get records 40 or more days old with last 40 days as ref.
i.e. it should ignore first 40 days from current date and display records older than that date.