#1
|
|||
|
|||
Rules based due date calculation
Good evening Can someone point me to a link or article on tracking legal calendaring? If I can find an example I can write VBA to suit our specific needs. I can do this in Excel or from Access data with the output writing in an Outlook calendar. I am not asking for a solution, just getting pointed in the right direction. We need to enter an event (ex. Complaint), an event date (date filed) and then calculate deadline dates (must be served by date, date answer due, etc.). For each different type of event, there would a different set of rules and for different courts (state court, federal court) Thanks for your help. -DL |
#2
|
||||
|
||||
It would be helpful if you gave some indication of the jurisdiction(s) you're concerned with (eg what country)! There's nothing in your post or your public profile that even gives a hint about that ...
Also, not only may there be Quote:
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Rules based calendaring
Location: Nevada, USA
However, the location is irrelevant to a solution. Each jurisdiction, as you noted, may have different rules, and local courts within the same jurisdiction will have specific rules. For now, I am looking for the simplest approach, probably using Excel and VBA to post to Outlook. I only need to track half a dozen courts. The rules would have to know whether the date calculation uses calendar days, business days, court days and court holidays. Later, we could do something better. Refine the data more specifically by using a relational database with lookup tables and unique keys for setting relations. Thank you -DL |
#4
|
||||
|
||||
Quote:
Really, there isn't anything complicated about adding x days to an input date to calculate an output date. As you've hinted, what might make the calculation complicated in some cases is accounting for weekends and for public holidays that vary from one locale to another - especially those public holidays that, like Good Friday and Easter Monday (which some places don't celebrate), are quite moveable. Where I live, some public holidays are even specific to particular cities within a state ...
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Tags |
court due dates, legal calendaring |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Rules based dates | dlowrey | Outlook | 1 | 05-12-2013 07:48 PM |
Date Calculation | Lights | Excel | 5 | 04-18-2012 04:31 AM |
calculation of start date | ketanco | Project | 1 | 02-29-2012 07:01 AM |
Outlook filing my incoming messages based on rules I apply :( | dmbegg | Outlook | 0 | 09-19-2011 01:51 PM |
server based rules | Babs27 | Outlook | 1 | 01-01-2011 07:21 PM |