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
This will return an integer for hours: HOUR(Duration)
So, this should work: HOUR(Today()-[Purchase Date])/โฆ
@RezaRaoofi That did it!
Thanks so much โฆ
Anytime Dave.
#SOLVED
User | Count |
---|---|
33 | |
31 | |
30 | |
19 | |
18 |