Convert date to number

[jamphan]

I would like to convert a date field to a number in a query. What I am trying to do is take 2 date fields and see how many days they are apart. For example if one date is 3/1/07 and the other is 3/1/06 I would like 365 days to be returned. Thanks for any help!

 

[KeithG]

check out the datediff function

 

[neileg]

Dates are stored as numbers in Access, so usually you can simply subtract one from another and get the right answer. To be absolutely correct, you should use DateDiff(). This ensures that the calculation works with external date data which may not be stored as a number in the way that Access does it.