Calc # of days between two dates

[laina222]

I think this is simple, just never done it before.

I need to write a query that will calculate the number of days between two dates. Basically it'll be the number of days a contract was in effect. I have three fields - Contract#, DateIssued, DateExpired. I want to get the Contract# and the number of days it was in effect in my results.

Any ideas? Thanks in advance!

 

[earthandfire]

Try

=DateDiff("d",[Date1],[Date2])

Hope this helps

 

[PHV]

You may try something like this:
SELECT [Contract#], DateIssued, DateExpired, 1 + CLng(DateExpired - DateIssued) AS CountOfDays
FROM yourTable
WHERE DateExpired Is Not Null;

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244