Date Rounding

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

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
 
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
Click to expand...

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

John W. Vinson[MVP]
 
aMack said:
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?
Click to expand...


The time part can do that. Try this instead:

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