Subtract Two Dates

[DBFIN]

I have two date fields. I want to subtract them to determine the number of days elapsed. The dates are in the following format: Dateserial(Year,Month,Day). When I subtract them I get 7670 as the result when the number should be 365 if they are a year apart.

How can I subtract the dates in a query?

 

[plog]

To subtact dates you generally use the DateAdd function (http://www.techonthenet.com/access/functions/date/dateadd.php)

 

[jdraw]

It would help readers if you showed the code you used, along with the input data and the output you received.

 

[DBFIN]

The syntax I use was actually correct. 7670 was a result for two dates that were 21 years apart, so problem resolved. Thanks again !!!!!!