Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
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