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

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
but there can even be different rules for the same court depending on the legislation governing the type of action.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

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

So, if someone from Pakistan posts a solution that works there, that would suit your needs? Somehow I don't think so.

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]