Subtract 5 hours from Date

[Sid244]

I am trying to subtract 5 hours using the following equation:
I want to show the date and the time.

Date({DB_Table.date1}) + Time({DB_Table.date1}-Hour(5))

For example:
DB_Table.date1 is showing 20:55:42
and I want to subtract 5 hours so the new time is: 15:55:42.

Thanks in advance for the help!!!!

 

[IanWaterman]

Use a formula

@NewDate
dateadd("h", -5, {DB_Table.date1})

Ian

 

[Sid244]

Thanks Ian. That is what I was looking for.