hello, i have a query that subtracts two columns. One column is the Date with most recent data, the second column is the date when the data was requested. I want to subtract the date of the request from the date of the most recent data, and if this number is more than 4 BUSINESS DAYS, then to show up in the query.
i can get the query to calculate this, but it includes saturday and sunday in the calculation. please help. thanks