query between 2 dates for total days between

[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.

 

[Tom Ellison]

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

 

[Guest]

Thanks Tom will try that and get back to you.

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

 

[JoCraig]

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.