Full Version: Best way to Calculate Date
UtterAccess Discussion Forums > Microsoft® Access > Access Queries
amydavis
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.
balaji
Search on UA for "networkdays" and you will find code to exclude weekends and holidays from calculations involving aging of dates.
amydavis
Yeah, I don't get it. I don't write code much so it looks pretty foreign to me.
amydavis
Nevermind. I got it to work in another way. Thanks!
balaji
Glad you got it sorted. Good luck with your project. thumbup.gif
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.