Subtracting dates

[notreconised]

on a report i have to boxexs which display a start time and finish time from a table i need to subtract the two dates/times from each other to leave the diferance in hours
ie 14/3 0600 - 16/3 0810 = 50.10Hrs

i have tried subtractin in contoll source but thids makes no calculation for days

thanks for any help in advance

 

[GHolden]

You can use DateDiff

eg.

DateDiff("h", date1, date2)

date difference between date1 and date2 in Hours

There are two ways to write error-free programs; only the third one works.

 

[mcfaddea]

Also as long as you have formatted your dates correctly you can do a straight forward subtraction in any field.

i.e. DateDiff = ([enddate]-[startdate])*24

where 24 is number of hoursin day.

This of course won't work for short/long day