Date Calculation

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

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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Text to date format? 0
Julian Date Question (Another) 4
printing report with date 3
Dlookup 7
Dates 4
Date Format when Exporting 5
Query 2
Date format when exporting 2

Back
Top