Subtract 3 hours from a date
Summary
Subtract 3 hours from a dateContent
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.
0