Difference between two dates

[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

 

[Allen Browne]

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

 

[Guest]

Thanks.

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.

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