Show limits of a data interval ... formatted

[Hugo Moner]

Hi guys
I've executed this query successfully...

SELECT NAME,DATE_FORMAT(DATEBORN,'%d/%m/%Y') AS BDAY WHERE WEEK(DATEBORN) = WEEK(CURRENT_DATE()) ORDER BY DATEBORN ASC

This script is executed every friday with cron, and shows all the people whom had birthday in last 7 days...

Now, How could I modify query to show something like:

"Listing of people whom had birthday between 20/07/2005 and 27/07/2005" (I'd like to know how to get the date limits in this interval of 7 days selected)

I mean, how to show date interval/range of people whom were selected in the script execution, no matter which day script was execd.

Thanks a lot in advance. hope you've understood me...