Date Calculation

K

Kirt84

I have two date fields in the format of dd/mm/yyyy. I want to be able to do a
calculation where it calculates the difference between the two dates.
Therefore the output will display the number of days.
 
F

fredg

how does this work??
Click to expand...
Use an unbound control on your form or report.
Set it's control source to:

=DateDiff("d",[Field1],[Field2])

This value should not be saved in any table.
 
Top