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.
How To: Add a number of Days to a Date for inclusion on a report
Content
Question: How can I include a date on my report which is some other date field + X Days.
Answer: (SEE ATTACHED DOCUMENT FOR DETAILS WITH SCREEN SHOTS)
- You may use the ADD_DAY function in Expressions to create a field which can then be included in your report layout.
Steps:
1. On Select Fields And Parameters UI, make sure you have the date field you want to use as the basis for your formula selected for the report. (Hire Date in this example).
2. In the Expressions section, click Add Expression link.
3. Give the Expression a Name.
4. In Expression field type "AD' and choose ADD_DAY function from teh autosuggest list. (or just type ADD_DAY(,) )
0