Calculating Future Dates

TLJ

Registered User.
Local time
Today, 16:45
Joined
Aug 17, 2003
Messages
31
future date calculation on a form

I want to be able to calculate a future date based on changing vaiables. I have a form with the following fields: sentence date, release date, expiration date, incarceration in days, incarceration in months. I am projecting a release date of probation.

Okay I need to project the date from a given date caculated one of two ways. For instance Some sentences will read 7 years, serve 4 mos in jail. The expiration date would be 6 years, 8 mos from the release date - one day.

Other sentences could read 7 years, 120 days jail. In this case the expiration date would be 6 years 245 days from the release date - one day.

The days one spends in jail is dependent on earned credits or working as a trustee so we figure the probation portion from the release date. This should be easy to do, but I am stumped.
 
Convert years to months and lookup the DateAdd() function on both this forum and the Access help files.
 
thanks, I got it to work using dateAdd to do the months.
 

Users who are viewing this thread

Back
Top Bottom