nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Date functions on BI publisher

Clifton Marodi

Summary

Date functions on BI publisher

Content

Hi,

I'm trying to add a year to a 'date_to' field but I can't find function on BI publisher. I need the function to return a year later than 'date_to' e.g. If DATE_TO = 31-Mar-15, I want it to return 31-Mar-16

I keep getting function for difference between dates: <?xdoxslt:date_diff(‘y', ‘YYYY-MM-DD’, ‘YYYY-MM-DD’, $_XDOLOCALE, $_XDOTIMEZONE)?>

Thanks in advance

Find more posts tagged with

Accepted answers

All comments

Thomas Dodds

Why not do it in the query in the data model? simple and straightforward

Venkata Allam-Oracle

Upload RTF template layout & sample xml data. Will do test case and come back with update.

Regards,

Venkat

Venkat Thota - BIP

what is your data source ? Thanks

Brajesh Shukla-95078

You can do below

<?xdofx:to_date(INVOICE_DATE,'DD-MM')?>-<?xdofx:to_date(INVOICE_DATE,'YYYY')+1?>

Clifton Marodi

Hi everyone , Thanks a lot for your help. I used Brajesh's function: <?xdofx:to_date(INVOICE_DATE,'DD-MM')?>-<?xdofx:to_date(INVOICE_DATE,'YYYY')+1?>

it worked like charm.

Your help appreciated.

Brajesh Shukla-95078

Mark this as answer if this is solved this will help others