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

(David Hopkins) #1

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

(Reza Raoofi) #2

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

(Reza Raoofi) #3

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

(David Hopkins) #4

@RezaRaoofi That did it!

Thanks so much …

(Reza Raoofi) #5

Anytime Dave.

(David Hopkins) #6

#SOLVED