You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Subtract 3 hours from a date

Accepted answer
edited Dec 13, 2022 7:04AM in Taleo Enterprise 5 comments


Subtract 3 hours from a date


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)



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. 

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!