Subtract 3 hours from a date

Summary

Subtract 3 hours from a date

Content

Hi All, I'm trying to subtract 3 hours from a date and cannot get the formula to work.

 

Formula in BO

=RelativeDate([Job Offer - Actual Start Date];-0.2083333)

 

OBI

TIMESTAMPADD(SQL_TSI_DAY,0.2083333,  "Job Offer - Actual Start Date"."Job Offer - Actual Start Date")

This formula in OBI is not working as expected. I think part of the problem is it's adding days not hours but if I change it to hours, I get a syntax error which is related to improper data type.

I've also tried to leverage this syntax but replacing the date but again I'm getting a syntax error.