Need to adjust time

[cardimom]

The field I need to use shows the time as 6 hours later then the actual time. How do I change this to my current time which is that field - 6 hours. The field is lastbackuptime. I tried lastbackuptime- 6 but that didnt do anything

Thanks
Cardimom

 

[mbarron]

I don't know if the follow are available for versions earlier than CR8.

If it's a DateTime field - use this formula:
DateAdd("h",-6,{lastbackuptime})

If it's a Time field - use this formula:
TimeSerial (hour({lastbackuptime})-6, minute({lastbackuptime}), second({lastbackuptime})) Mike