Dates

  • Thread starter Thread starter Vince
  • Start date Start date
V

Vince

I need to create a formula that would take the next date
in a database and subtract one date and attach that to the
above record. For Eg. If Date 1 is 05/14/1995 and Date 2
is 07/01/2002, then I need a formula to attach 06/31/2002
to date 1 record. Thanks
 
Vince

If you can do this calculation, you may not need to actually store the
calculated value. What will having "6/31/2002" allow you to do?

More info, please...

Jeff Boyce
<Access MVP>
 
There is generally no good reason to store a value that can easily be
calculated. Especially this particular date since June has only 30 days ;-)
 
Back
Top