```
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.

**Problem:**

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.