Posted By: sanchezgmc06 — 7 Jul 2023 at 8:41am
Hello I have a date parameter where the user will select a date on a Saturday.
I then want it to pull the data for Sunday-Saturday.
Example they enter 7/1/2023 for the parameter date and then I want to bring back the data for Sunday 6/25 - Saturday 7/1.
Thank you
Posted By: lockwelle — 7 Sep 2023 at 12:05pm
You have probably already figured this out.
I would have the user input be a paramater, and I would set the date range to be DATEADD("day", -6, @userInput)
This could be set to a variable or hopefully passed to procedure or used in the select clause. Whichever way you are retrieving your data.
It's been a while, I think that should work.
