Calculating 2 date field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form and would like field C to be automatically calculated in a
form. The formula being Datefield A - DatefieldB = field C

can this be done?
 
Nope.

You would not want to store a calculated value. When you need the value,
just recalculate it.

Storing the value would lead to all kinds of trouble. What if you changed
one of the dates, but forgot to fix your calculated field?

Search through here and you will find a hundred posts explaining why you do
not store a calculated field in a table.

There are some exceptions, but I can't think of a case where subtracting two
dates would be one of them.

Rick B
 
Back
Top