[AccessD] Date difference

Hi Ray

1. July 2003 00:00 is the beginning of the day.
1. July 2003 23:59 is the last minute of the day.

/gustav


> If we find the date difference between two dates using datediff
> function, it may end up an inaccurate difference.  For example, the
> start date is 1 July, 2003 and the end date is 5 July, 2003.  The
> difference is 5 days.  The answer may be right or wrong.  If the start
> date is 1 July 2003 00:00 and the end date is 6 July 2003 00:00.  The
> accurate answer should be 3-5 days.  If we ask the staff to record the
> time of start date and end date, human delay and error may happen too
> unless there is an aid of time recorder.  I would like to know the
> general perception of this issue.