Displaying date

[Alex H]

Hi - hope someone can help me.

I have a table which contains two date fields - Start Date and End Date and
an event field
What I am trying to do and getting hopelessly lost is to select all the
events for the next seven days and within the two date fields.

Ialso need to display the date with the day name

Is this possible please

thanks

Alex