Need to calculate differrence between two dates (show actual # of days) in report

[mulberry13]

I created a query to run a report and this is what I have in the "query":

Length of stay: [Date Closed]-[Date Opened]
Ex: if the start date is June 18/2009 and the closed date is 5/3/2009 it shows 319 instead of showing me actual days/months/years. How can I format this in the report to show that?

 

[alansidman]

You will have to do some calculations to show the difference in years, the remainder in months, calculate the remainder in days to achieve what you are looking for. You will probably need to use the DateDiff function. Here is a link on its syntax.

http://www.techonthenet.com/access/functions/date/datediff.php

Alan

 

[Montez659]

Removed post.

 

[mulberry13]

Thanks so much for the link (much easier to follow)!