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
41
Views
5
Comments
edited Dec 14, 2016 2:50PM in Reporting and Analytics Taleo Enterprise 5 comments

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. 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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