Here we go again.. lol Im trying to determin...

[David_Hopkins]

Here we go again… lol

Im trying to determine the yearsOwned on a car…

Simply put…

(((Today()-[Purchase Date])/24)/360) or (Today()-[Purchase Date])/8640)

When I derive the duration between Today and PUrchase Date I get something like …

19128:00:00

Which equates to the number of hours that I’ve owned the car. I need to divide that 19128 / 8640 to equal 2.2 years…

however…

19128:00:00 is not a divisible value.

suggestions on how to get that number divisible?

Thanks all …

dave

[RezaRaoofi]

This will return an integer for hours: HOUR(Duration)

[RezaRaoofi]

So, this should work: HOUR(Today()-[Purchase Date])/…

[David_Hopkins]

@RezaRaoofi That did it!

Thanks so much …

[RezaRaoofi]

Anytime Dave.

[David_Hopkins]

#SOLVED