Bi Publisher SYSDATE - 1 calculation

Question

Summary

Content

I am trying to display today's date minus one on my BI Publisher report.  In the advanced BI Publisher Properties tab I have the following command; <?xdofx:(sysdate()-1)?>.  What is displayed on my PDF output is 'NaN'.

Brajesh Shukla-95078 · Answer

Please use

<?xdoxslt:sysdate()-1?>

Vani-R · Answer

Iam sure it should be possible using xml tags in bi publisher. But, why dont you try using formula field in RDF and get the value using SQL query. This is not linked to original query and will return value irrespective of query returning rows.

Yogen · Answer

calculate sysdate-1 in your data source it self...get it as a column in datamodel and use it the way you want it.