Skip to main content
Participating Frequently
June 7, 2006
Answered

BETWEEN DATES

I have been using a piece of code in a query that works fine with Access but not with mysql. i need to show all the records that fall between NOW() and the next three days.

Could anyone help with the code necessary to get the same to work with mySQL.

Thanks
This topic is closed to new replies. Start a new post to keep the conversation going.
Dan_BracukCorrect answer
Inspiring
June 7, 2006
replace now() with current_date

2 replies

pwizzardAuthor
Participating Frequently
June 7, 2006
Perfect, thanks very much.
Translate
Dan_BracukCorrect answer
Inspiring
June 7, 2006
replace now() with current_date
Translate