Hello All,

I have a query which I run monthly against a table of information. For the date range I use the below formula to automatically receive the previous months data. I am trying to modify this forumla to accomplish the following:

1. Query the previous week's data
2. Query month to date data.

Any idea's on how I could modify this formula to accomplish my goals or perhaps two new formulas to accompish this?

Thanks!



Between DateAdd("m",-1,DateAdd("d",-Day(Date())+1,Date())) And DateAdd("d",-Day(Date()),Date())