I am sorry. You are correct I could just do that. What I was wondering if I can do it based on today's date so it would be more dynamic so when the report is run for the next month it automatically selects the correct dates.
You could calculate them, but you need to define the logic to define which week belongs to which month (and year).
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2