Date Difference

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/
 
K

Ken Snell

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])
 
I

Israel Rodriguez

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/
 
K

Ken Snell

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