Guys,

I would like to know how to retrieve data between from a monday to sunday

For example from the 17th to 23 feb2003.I don't want to hard-code the dates but i want to tell the query to pull the data from monday to sunday of previous week


thanks for help in advance.