Report Goal: User inputs the Friday for the weekend they would like to see what items are Starting or Ending during that weekend (Saturday, Sunday, Monday).
So Far: I've set up the <Ask the User> to input both the start/end dates. I've also set up a formula field that looks at the Start and End Dates and assigns the day of the week to them.
Issue: I cannot find a way to indicate ONLY DURING THE WEEKEND INDICATED between the start and end dates and have it be available any time based on the start and end dates input by the user.
For now, the report is pulling properly if you pull it during the week before the next weekend, but if you were to pull it over the current weekend (say on Sunday), you will not see the items from Saturday. The other issue is that even if I put in the dates from last weekend it still only shows this weekend's information because of the second line in my report criteria (7 days in the future - which always means 7 days from TODAY, not from the date indicated by the user). Is there a way to do + or - 4 days from date indicated?
Thanks for any creative ideas on making this happen!! I've included a screen shot on how I've set up the criteria, I probably would be able to make this happen with one more level down but Quickbase does not want me to go there!
So Far: I've set up the <Ask the User> to input both the start/end dates. I've also set up a formula field that looks at the Start and End Dates and assigns the day of the week to them.
Issue: I cannot find a way to indicate ONLY DURING THE WEEKEND INDICATED between the start and end dates and have it be available any time based on the start and end dates input by the user.
For now, the report is pulling properly if you pull it during the week before the next weekend, but if you were to pull it over the current weekend (say on Sunday), you will not see the items from Saturday. The other issue is that even if I put in the dates from last weekend it still only shows this weekend's information because of the second line in my report criteria (7 days in the future - which always means 7 days from TODAY, not from the date indicated by the user). Is there a way to do + or - 4 days from date indicated?
Thanks for any creative ideas on making this happen!! I've included a screen shot on how I've set up the criteria, I probably would be able to make this happen with one more level down but Quickbase does not want me to go there!
