3 columns with different dates

  • Thread starter Thread starter Jenn
  • Start date Start date
J

Jenn

I have a report for toners and I need to track how long
they last. I have to compair between 3 dates. Right now
I have 2 colums and I am using the formula

DifferenceDate: DateDiff("d",[StartDate1],[EndDate2])

I would like to add in another column with a 3rd date. Is
that possible?

Please let me know.

Thanks
Jenn
 
I have a report for toners and I need to track how long
they last. I have to compair between 3 dates. Right now
I have 2 colums and I am using the formula

DifferenceDate: DateDiff("d",[StartDate1],[EndDate2])

I would like to add in another column with a 3rd date. Is
that possible?

Please let me know.

Thanks
Jenn
Click to expand...

Sure... what result do you want to see if you have three dates? How do
you want them compared?

That is, if you have #2/1/2004#, #4/18/2004# and #5/3/2004#, what's
the "right answer"?
 
I want a total number of days between date 1 and date 2
and then I want a total number of days between date 2 and
date 3.
-----Original Message-----
I have a report for toners and I need to track how long
they last. I have to compair between 3 dates. Right now
I have 2 colums and I am using the formula

DifferenceDate: DateDiff("d",[StartDate1],[EndDate2])

I would like to add in another column with a 3rd date. Is
that possible?

Please let me know.

Thanks
Jenn
Click to expand...

Sure... what result do you want to see if you have three dates? How do
you want them compared?

That is, if you have #2/1/2004#, #4/18/2004# and #5/3/2004#, what's
the "right answer"?



.
Click to expand...
 
I want a total number of days between date 1 and date 2
and then I want a total number of days between date 2 and
date 3.
Click to expand...

Ok... two separate and independent calculations then;

DateDiff("d", Date1, Date2)

DateDiff("d", Date2, Date3)

in two separate calculated fields. Or am I missing something?
 
-----Original Message-----


Ok... two separate and independent calculations then;

DateDiff("d", Date1, Date2)

DateDiff("d", Date2, Date3)

in two separate calculated fields. Or am I missing something?


.
No That is exactly what I wanted, and it worked. Thank
Click to expand...
you very much.
 
Back
Top