AnsweredAssumed Answered

Help with calculations

Question asked by planbcm on Oct 1, 2014
Latest reply on Oct 1, 2014 by philmodjunk

Title

Help with calculations

Post

 

Being new to FM, I am trying to design a report for the transport industry.

1.
I have a vehicle come in for inspection = Date In
Vehicle leaves inspection = Date out.
Date out - Date in = Days in workshop

2. I need a calculation for the number of days between Date Out and the next Date In

or

Date In - last Date Out this needs to give me the period in days between inspections

It would also be good to show the number of days 42 until next inspection date

3. When the vehicle comes in I also need to record the odometer.
I need to calculate Odometer In - Last Odometer In to give total miles travelled

Thank you in anticipation

Outcomes