Hi,
I have an unbound text box in a report which calculates how long a client has been on a service, with this control:
=DateDiff("d",[date_of_referral],[discharge_date])
However, it does not seem to calculate how I need it to.
For instance, if the date_of_referral is 28/09/2013 and the discharge_date is 30/09/2013, then the field above shows 2 days, which IS the difference between the two dates.
However, for our records, the client was on the service for 3 days, on 28th, 28th and 30th.
Do I need to change DateDiff to something else in order to calculate this correctly?
I considered making it plus 1 to the datediff, but this wouldn't work when the client was on the service for one day.