Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-12-2013, 07:33 PM
dlowrey dlowrey is offline Rules based due date calculation Windows 7 64bit Rules based due date calculation Office 2010 32bit
Novice
Rules based due date calculation
 
Join Date: Feb 2012
Posts: 29
dlowrey is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 05-12-2013, 07:45 PM
macropod's Avatar
macropod macropod is offline Rules based due date calculation Windows 7 64bit Rules based due date calculation Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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:
a different set of rules and for different courts (state court, federal court)
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]
Reply With Quote
  #3  
Old 05-12-2013, 08:16 PM
dlowrey dlowrey is offline Rules based due date calculation Windows 7 64bit Rules based due date calculation Office 2010 32bit
Novice
Rules based due date calculation
 
Join Date: Feb 2012
Posts: 29
dlowrey is on a distinguished road
Default 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
Reply With Quote
  #4  
Old 05-12-2013, 08:30 PM
macropod's Avatar
macropod macropod is offline Rules based due date calculation Windows 7 64bit Rules based due date calculation Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by dlowrey View Post
Location: Nevada, USA

However, the location is irrelevant to a solution.
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]
Reply With Quote
Reply

Tags
court due dates, legal calendaring

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Rules based due date calculation Rules based dates dlowrey Outlook 1 05-12-2013 07:48 PM
Rules based due date calculation 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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:17 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft