Date Difference

  • Thread starter Thread starter Israel Rodriguez
  • Start date Start date
I

Israel Rodriguez

I'm trying to set up a report where, based on data inputed in this
form, we have a two dates inputed, with the report showing thise dates
and the difference between the two dates, aka
Date3=Date2-Date1
Can anyone give me an idea on this?

Israel Rodriguez

http://home.earthlink.net/~isrodriguez7/
 
Not sure of what you're doing, but you can use the DateDiff function to get
the difference between two dates (See Help files for more info).

You can use this as the control source of a textbox on a form or report:
=DateDiff("d", [Date1], [Date2])
 
Not sure of what you're doing, but you can use the DateDiff function to get
the difference between two dates (See Help files for more info).

You can use this as the control source of a textbox on a form or report:
=DateDiff("d", [Date1], [Date2])
Click to expand...

I was thinking in terms of the difference in days between the two
dates.

Israel Rodriguez

http://home.earthlink.net/~isrodriguez7/
 
The example that I've given does exactly that.

--
Ken Snell
<MS ACCESS MVP>

Israel Rodriguez said:
Not sure of what you're doing, but you can use the DateDiff function to get
the difference between two dates (See Help files for more info).

You can use this as the control source of a textbox on a form or report:
=DateDiff("d", [Date1], [Date2])
Click to expand...

I was thinking in terms of the difference in days between the two
dates.

Israel Rodriguez

http://home.earthlink.net/~isrodriguez7/
Click to expand...
 
Back
Top