Date range excluding Specific week or dates 1

[Dausa67]

Good afternoon and Merry Christmas,
Is it possible to exclude a specific week or dates with-in an existing date range?

We will be off work next week so I do not want to populate that week on my report.

My report is ran every Monday morning with the date range of 20 weeks. The purpose of the report is sum the number of parts approved each week and chart the progress.

My date range code so far is:

{PBOM_PUR_PART_VENDORDATA.PUR_FINAL_APPR_DATE} in Currentdate -1 to Currentdate - 140

Thank you in advance for your help.

Clay

 

[fisheromacse]

i think you should be able to add the below to your current date selection formula.
You could then either create From & To parameters or replace them with the actual dates.


AND
(NOT({PBOM_PUR_PART_VENDORDATA.PUR_FINAL_APPR_DATE}) IN [{%FromDate} to {%ToDate}])