Oracle Communities

Oracle Analytics and AI

Child Item

Is there any function available to get day of the week in RTF BI publisher

Kaustubh Deshmukh

Is there any function available to get day of the week in RTF BI publisher

let say i have some date comming in XML format as below :

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

Not getting any date function to get day of the week like Sunday as 1 ,mon as 2 like …. etc

Find more posts tagged with

Submitted

BI Publisher

BI Publisher Report Templates

Status: Submitted

Comments

Gianni Ceresa

Not sure if you really want to submit an idea for this, is that really what you want?

Or you are just asking how to do it, like you did in the thread posted in the right category?

I believe this idea can be closed and discarder as posted in the wrong place…

https://community.oracle.com/products/oracleanalytics/discussion/22128/is-there-function-available-for-getting-day-of-the-week-from-any-date-field-in-rtf-template

Kaustubh Deshmukh

Hi Gianni,

We want to do some date logics from our XML data but In oracle we dont have xdo or xslt function directly available for extracting day of the week form any dates , hence i raised this idea if we have any scope of implementing this that will help for BIP reports.