mulberry13
Board Regular
- Joined
- Nov 23, 2005
- Messages
- 204
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?
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?
