Business Objects report add 15 days to a date

I have a date field in a report in Business Objects. I want to create another field in the report that adds 15 days to that date.
PdetersAsked:
Who is Participating?
 
PdetersConnect With a Mentor Author Commented:
This is what I needed to put in the Business Objects report

=RelativeDate([Closing Date];15)
0
 
sdstuberCommented:
just add a column to your query that does the calculation



select your_date_column,  your_date_column  +15 newcolumn
from your_table
0
 
PdetersAuthor Commented:
that is not working - states invalid data type
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

 
sdstuberCommented:
is your date column really a date?

or is it a string or number or something else?
0
 
PdetersAuthor Commented:
yes
0
 
sdstuberCommented:
must be a BO problem then, not in Oracle

date math is quite simple in oracle.

adding 15 days is done exactly as shown above.
0
 
Walter RitzelSenior Software EngineerCommented:
As sdstuber says, maybe your problem is that your date is not really a date, so you can alter the sql provided by him this way:

select your_date_column,  to_date(your_date_column,'yyyy-mm-dd') +15 newcolumn
from your_table

remembering that you should change your date format to the format used by your text field that represents a date.
0
 
Walter RitzelSenior Software EngineerCommented:
Humm, are you using Infoview to create reports? Or are you Crystal Reports?
0
 
sdstuberCommented:
when I said it must be a BO problem, I was assuming "yes" referred to the first of the choices I mentioned.

if "yes" was an affirmative to one of the other choices, then please elaborate
0
 
PdetersAuthor Commented:
none of the other answer worked and this is what is needed in Business Objects to get the answer
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.