P
Patty
How do I calculate the number of days between a field date and a particular
date?
date?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
BruceM
You seem to be aware you would use the DateDiff function, as it is in the
Subject line of your question. In a query:
ElapsedDays: DateDiff("d",[Field1],[Field2])
Field1 and Field2 are generic names for the date fields. Use your actual
field names. Likewise, ElapsedDays can be a name of your choice.
Alternatively, as the Control Source of an unbound text box:
=DateDiff("d",[Field1],[Field2])
Subject line of your question. In a query:
ElapsedDays: DateDiff("d",[Field1],[Field2])
Field1 and Field2 are generic names for the date fields. Use your actual
field names. Likewise, ElapsedDays can be a name of your choice.
Alternatively, as the Control Source of an unbound text box:
=DateDiff("d",[Field1],[Field2])
D
diazmaggi
Patty said:How do I calculate the number of days between a field date and a
particular
date?
K
KARL DEWEY
DateDiff("d",[Date1],Date2])
But remember the the difference between 3 July 09 and 4 July 09 is one day
and the difference between 3 July 09 and 3 July 09 is zero days. So you need
to add one to the difference.
But remember the the difference between 3 July 09 and 4 July 09 is one day
and the difference between 3 July 09 and 3 July 09 is zero days. So you need
to add one to the difference.