Difference between two dates

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

Guest

Is there a way in which i can determine the difference in date between the
date stored in a field and the end date of a query request?

example:

Field has date of 1/1/07. Query asks for a date range. Date range given is
1/1/07 - 1/31/07. I want to be able calculate the difference between the end
date and the field date
 
If the field name is Field1, and the query asks for a parameter named [Wot
End Date], use:
DateDiff("d", [Field1], [Wot End Date])
 
Thanks.

Allen Browne said:
If the field name is Field1, and the query asks for a parameter named [Wot
End Date], use:
DateDiff("d", [Field1], [Wot End Date])

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Brett said:
Is there a way in which i can determine the difference in date between the
date stored in a field and the end date of a query request?

example:

Field has date of 1/1/07. Query asks for a date range. Date range given
is
1/1/07 - 1/31/07. I want to be able calculate the difference between the
end
date and the field date
Click to expand...
Click to expand...
 
Back
Top