• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 972
  • Last Modified:

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.
0
Pdeters
Asked:
Pdeters
  • 4
  • 4
  • 2
1 Solution
 
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
 
sdstuberCommented:
is your date column really a date?

or is it a string or number or something else?
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
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:
This is what I needed to put in the Business Objects report

=RelativeDate([Closing Date];15)
0
 
PdetersAuthor Commented:
none of the other answer worked and this is what is needed in Business Objects to get the answer
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

  • 4
  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now