Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Date functions on BI publisher
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
Answers
-
Why not do it in the query in the data model? simple and straightforward
0 -
Upload RTF template layout & sample xml data. Will do test case and come back with update.
Regards,
Venkat
0 -
what is your data source ? Thanks
0 -
You can do below
<?xdofx:to_date(INVOICE_DATE,'DD-MM')?>-<?xdofx:to_date(INVOICE_DATE,'YYYY')+1?>
0 -
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.
0 -
Mark this as answer if this is solved this will help others
0