date + 7 days....please help

[imstillatwork]

I have a date in my database:
I need two things:

1.) To be able to SELECT dates in the database, ignoring the YEAR. I give day and month, I want all records matching, regardless of year.

2.) To be able to SELECT by todays date, and get every record for today (again, ignoring the year) and 7 days ahead.

If todays date is 5/5, I want to SELECT records from 5/5 to 5/12
but what happens if I today is 5/24? I want dates 5/24 to 6/2. make sense?

any ideas? i know it isnt that hard for you guys!

 

[imstillatwork]

I know haow the BETWEEN statment works. I need to know how to format my dates to get the following 7 days...
thanks

 

[imstillatwork]

thanks any way... I found it....

 

[imstillatwork]

This seems to work. I seem to be talking to myself. OK, If anyone want to try this, let me know how it does. a few requirments....
dates must stored in as varchar in m/d/yyy NOT mm/dd/yy format.

<cfset date1 = dateformat(now(), &quot;m/d&quot>
<cfset date2 = dateformat(dateadd(&quot;d&quot;, 7, date1), &quot;m/d&quot>

<cfquery name=&quot;getall&quot; datasource=&quot;test&quot;>
SELECT * FROM tblDATE
WHERE datein BETWEEN '#date1#%' AND '#date2#%'
</cfquery>

<cfoutput query=&quot;getAll&quot;>
Name: #name#, DOB: #DateIN#<br><br>
</cfoutput>