Categories
- All Categories
- 4 Oracle Analytics Videos
- 13.7K Oracle Analytics Forums
- 5.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 56 Oracle Analytics News
- 31 Oracle Analytics Trainings
- 52 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
Bi Publisher - add x days to a date element in rtf template
Answers
-
Hello
You can use the
https://blogs.oracle.com/xmlpublisher/entry/groovy_date_functions
<?xdoxslt:ora_format_date_offset('2009-06-03',position(), '+')?> , as per blog example
Regards
Gabriel1 -
Many thanks for your response.. Found an other means just now with a bit of trial and error..
<?format-date:(xdoxslt:ora_format_date_offset(xdoxslt:ora_format_date(PRINT_DATE_TIME,'YYYY-MM-DD'),14,'+'));'DD MONTH YYYY'?>
0 -
Dear
Thank you for your feedback and also i'm glad that the issue has been resolved.
If one of the answers helped you or answered to your request kindly please mark the answer as Helpful or mark as Correct Answer
Regards
Gabriel
0 -
Hi Team,
I have this requirements: To Add 1 day to payment date in the rtf but exclude week end.
I come up with this conditions below but no output when tried to display the date.
--PaymentDate xml value is 2022-06-03 --
<?xdofx:if to_date(PaymentDate,'D') = 6 then
format-date:(xdoxslt:ora_format_date_offset(xdoxslt:ora_format_date(PaymentDate,'YYYY-MM-DD'),3,'+'));'DD MONTH YYYY' -- Output date is monday
else
if to_date(PaymentDate,'D') = 7 then
format-date:(xdoxslt:ora_format_date_offset(xdoxslt:ora_format_date(PaymentDate,'YYYY-MM-DD'),2,'+'));'DD MONTH YYYY' -- Output date is monday
else
format-date:(xdoxslt:ora_format_date_offset(xdoxslt:ora_format_date(PaymentDate,'YYYY-MM-DD'),1,'+'));'DD MONTH YYYY' -- plus 1 day
end if?>
0 -
Hi everyone, just found this thread today.
I just wanted to share the way I did it, which is basically the same:
Adds ‘x’ number of days to the given date_in field <?xdofx:date_in?>. Output is rendered in the same date format as that of ‘date_in’ field.
Example using 'HIRE_DATE'
<?xdoxslt:ora_format_date_offset(HIRE_DATE,1,'+')?>
0 -
I have a <PAYMENT_DATE>2024-02-26</PAYMENT_DATE> column in XML file and I am using this value I need to bring back previous sunday and Saturday dates in RTF templates , Is there any function not available to get day of the week
0