I have a query which right now is subtracting two dates and then returning only those records which are <= 5. Here is a sample from the where clause: (av.status_date - av.requested_date) <=5. We have to report Turn around times and need to exclude weekends and holidays. Can anyone tell me how to do it in a query.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.