Pdeters
asked on
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.
ASKER
that is not working - states invalid data type
is your date column really a date?
or is it a string or number or something else?
or is it a string or number or something else?
ASKER
yes
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.
date math is quite simple in oracle.
adding 15 days is done exactly as shown above.
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.
select your_date_column, to_date(your_date_column,'
from your_table
remembering that you should change your date format to the format used by your text field that represents a date.
Humm, are you using Infoview to create reports? Or are you Crystal Reports?
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
if "yes" was an affirmative to one of the other choices, then please elaborate
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
none of the other answer worked and this is what is needed in Business Objects to get the answer
select your_date_column, your_date_column +15 newcolumn
from your_table