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