My Assistant
Site Message
(Message will auto close in 2 seconds)
  |
 Best way to Calculate Date
|
|
 Aug 27 2007, 02:04 PM
Post
#1
|
|
|
New Member Posts: 18  |
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. I assume I will run into the same issue with #2, but it should be applicable to both situations. |
 |
 
|
|
Aug 27 2007, 02:07 PM
Post
#2
|
|
|
UtterAccess VIP Posts: 5,635 From: Chicagoland, USA |
Search on UA for "networkdays" and you will find code to exclude weekends and holidays from calculations involving aging of dates.
|
|
|
|
|
Aug 27 2007, 02:35 PM
Post
#3
|
|
|
New Member Posts: 18 |
Yeah, I don't get it. I don't write code much so it looks pretty foreign to me.
|
|
|
|
|
Aug 27 2007, 02:49 PM
Post
#4
|
|
|
New Member Posts: 18 |
Nevermind. I got it to work in another way. Thanks!
|
|
|
|
|
Aug 27 2007, 03:12 PM
Post
#5
|
|
|
UtterAccess VIP Posts: 5,635 From: Chicagoland, USA |
Glad you got it sorted. Good luck with your project. (IMG:http://www.utteraccess.com/forum/style_emoticons/default/thumbup.gif)
|
|
|
|
 |
|
Jump To Forum:
|
Go to Top · Lo-Fi Version | Time is now: 22nd May 2013 - 09:19 PM |