S
Stockwell43
Hello,
I have a database that I am trying to calculate the time (in days minus
weekends and holidays) between the Original Date and the current date.
I'm not sure if this needs to be placed on the form, query or add a couple
of fields to the report but this is what I am trying to accomplish.
I have an "Original Date" field on the form. We have 10 days from that date
to payoff the loan and send out the title to the customer. When the manager
pulls a report, he wants to see the Original Date and the number of days that
have passed to see if he is within his 10 day window (again minus weekends
and holidays). I suppose I can place a checkbox on the form to show if the 10
days was met so as days are elapsing over day the checkbox will show it was
completed(he wants all the records to show for the month whether it's
completed or not because he is looking at other data on this report as well.
If this is possible without to much complication, any help would be most
appreciated! At best, if I can exclude weekdays I can place a checkbox to
show a holiday falls in the date range and he can subtract one day from what
is shown.
Thanks!!!
I have a database that I am trying to calculate the time (in days minus
weekends and holidays) between the Original Date and the current date.
I'm not sure if this needs to be placed on the form, query or add a couple
of fields to the report but this is what I am trying to accomplish.
I have an "Original Date" field on the form. We have 10 days from that date
to payoff the loan and send out the title to the customer. When the manager
pulls a report, he wants to see the Original Date and the number of days that
have passed to see if he is within his 10 day window (again minus weekends
and holidays). I suppose I can place a checkbox on the form to show if the 10
days was met so as days are elapsing over day the checkbox will show it was
completed(he wants all the records to show for the month whether it's
completed or not because he is looking at other data on this report as well.
If this is possible without to much complication, any help would be most
appreciated! At best, if I can exclude weekdays I can place a checkbox to
show a holiday falls in the date range and he can subtract one day from what
is shown.
Thanks!!!