I am trying to figure the best way to do this in a query. I have 2 objectives
1) Provide a list of borrowers that need call backs the day after their app submit date
2) Provide a list of borrowers that need a call back if we still have not received their app within 14 days of the submit date.
With #1: I am able to get the query to show me the borrowers I want just by saying iif([subdt]+1=date(),"call needed","") However I can not figure out how to account for the weekend since we are closed. So anything submitted Fri. evening to Monday 8am would need a call Monday. How should I do this.
Oassume I will run into the same issue with #2, but it should be applicable to both situations.