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

previous date from sysdate in XML publisher

Vsilvery

Summary

previous date from sysdate in XML publisher

Content

Hello,

how to get previous date from sysdate in XML publisher?

I want something like <?sysdate()-1?>

Find more posts tagged with

Accepted answers

All comments

Sherry George

Hi,

You could either try this <?xdoxslt:sysdate()-1?> or calculate the previous date in the dataset and use it in the report.

Vsilvery

Source Database is Oracle 11g.

Vsilvery

In report please

WVanSluys1

Are you wanting to do in Report Template or in Query?

What is your source database?

Vsilvery

<?xdoxslt:sysdate()-1?> output is not in correct format.

for example: if i generate output today(2017/25/04), its printing as "202504".

format is not changing even if i change property of this element.

yes, i included in dataset and used in template.

but i want to know method of using sysdate function in formula.

Brajesh Shukla-95078

This is preferable to calculate SYSDATE -1 in database and create XML tag for that. Because BI Publisher treat date as number so suppose you have 01-APR-2017 and you will do -1 for this it will print 00-APR-2017, this is not valid date. So better do it on database and use XML

Vsilvery

Thanks