query between 2 dates for total days between

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to write a query to find out the total number of days between two
dates. I don't know if my mind has just gone blank or what. But I can not
think of how to do it.
 
Dear Koko:

You could use the DateDiff() function. Information in "help" contains all
the details.

There may be more to it than that, but you don't give sufficient details to
begin to guess at that.

Tom Ellison
 
Thanks Tom will try that and get back to you.

Tom Ellison said:
Dear Koko:

You could use the DateDiff() function. Information in "help" contains all
the details.

There may be more to it than that, but you don't give sufficient details to
begin to guess at that.

Tom Ellison
Click to expand...
 
Hi Tom

I have a question about datediff in Access 2003.

I have written a dbase on leave for staff.

On their Leave form they write the first date of leave, eg. Mon 14 May and the last date of leave eg. Friday 18 May.

That is in total 5 days. However, when I use datediff in Access, it calculates this as 4 days.

Do you know if there a way to rectify this?

Thanks, Jo.
 
Back
Top