Calculating a future date

G

Guest

I have an application that tracks parole violations. I need to calculate a
due date for for the violation process to be done based on the date the
parole agent was notified of the violation. The agent has 14 "business days"
to serve the charges if it is not a PV only charge. I need to calculate the
date charges are due by, adding 14 days but skipping weekends and holidays.
I looked at the code on the MPVS sit on how to calculate working days but it
requires a known end date. Does anybody know how to accomplish the above or
is it even possible? Thanks.
 
G

Guest

Al Westerlund said:
I have an application that tracks parole violations. I need to calculate a
due date for for the violation process to be done based on the date the
parole agent was notified of the violation. The agent has 14 "business days"
to serve the charges if it is not a PV only charge. I need to calculate the
date charges are due by, adding 14 days but skipping weekends and holidays.
I looked at the code on the MPVS sit on how to calculate working days but it
requires a known end date. Does anybody know how to accomplish the above or
is it even possible? Thanks.
Click to expand...

Never mind, I dug deeper on the MVP site and found the answer I needed.
Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate a future date excluding weekends and holidays 4
Rogue future date field highlighting 3
How do I calculate future date after number of days 1
Access Ver 2.0 Adding days to a date to give target date excluding weekends? 2
Calculating a future date 7
Calculate End Date Using Start Date and No. of Days excluding specific days. 0
Calculate End Date (excluding weekends and holidays) 6
How do I calculate future dates excluding weekends and holidays? 1

Top