How to select data from today to 7 days later?

Question

I have a table which contains data.
Table name book.
Entity / column of table are :
id, id_book, id_user, date_borrow, date_return
I want to select date_return starting from today to 7 days ahead.

SELECT *
FROM `book`
WHERE `book`.date_return BETWEEN CURDATE() AND CURDATE()+7
I've try with query above, but not works.
What query is suitable for this situation???

Answer 1

select*from book where DateCol between adddate(now(),+7)and now()-----------I think u try that concept...