Date Calculation

[Guest]

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.

 

[Guest]

Use DateDiff function.

 

[Guest]

how does this work??
--
Thank you for your help

Use DateDiff function.

 

[fredg]

how does this work??

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.