Bi Publisher - add x days to a date element in rtf template

Question

Hi All,

Is there any function we can use to add 'X' days to a date element in an RTF template ?

One way I can think of is deriving it in the data model but just curious if any functions available in format:date or so  ?

Thanks in advance

Kaustubh Deshmukh · Answer

I have a 2024-02-26 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

User_B3V2A · Answer

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 . Output is rendered in the same date format as that of ‘date_in’ field. Example using 'HIRE_DATE'

Rey · Answer

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?>