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

How To: Add a number of Days to a Date for inclusion on a report

Question
31
Views
0
Comments
edited Feb 6, 2015 5:17PM in Reporting and Analytics (TBE)

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(,) )

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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