3 columns with different dates

[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

 

[John Vinson]

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

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"?

 

[Jenn]

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

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"?



.

 

[John Vinson]

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.

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?

 

[Jenn]

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

you very much.