Date Rounding

[Guest]

I am trying to perform a simple calc on 2 dates.

[Arrival date]-[Termination date]

The result sometimes gives me a number which is 1 more than I expect.

Is this because of the time built into the date field?

How do I modify the query to give me results based on the Date only?

Thanks

 

[John Vinson]

I am trying to perform a simple calc on 2 dates.

[Arrival date]-[Termination date]

The result sometimes gives me a number which is 1 more than I expect.

Is this because of the time built into the date field?

How do I modify the query to give me results based on the Date only?

Thanks

DateDiff("d", [Arrival Date], [Termination Date])

John W. Vinson[MVP]

 

[Marshall Barton]

I am trying to perform a simple calc on 2 dates.

[Arrival date]-[Termination date]

The result sometimes gives me a number which is 1 more than I expect.

Is this because of the time built into the date field?

The time part can do that. Try this instead:

DateDiff("d", DateValue([Arrival date]),
DateValue([Termination date]))