Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
datetime expression of yesterday
dianbo
I uses date-and-time expression in the filename and folder name in schedular jobs.
Is there any expression or substitution solution to express yesterday or last month?
Thanks
Dianbo
Find more posts tagged with
Comments
rmurphy
BIRT offers BirtDateTime functions as a sub-category of BIRT Functions. This subcatetory allows you to perform functions such as date math functions.
The following will give you a date object that represents a date on month prior to the current date:
BirtDateTime.addMonth(new Date(), -1)
Rob
dianbo
<blockquote class='ipsBlockquote' data-author="rmurphy"><p>BIRT offers BirtDateTime functions as a sub-category of BIRT Functions. This subcatetory allows you to perform functions such as date math functions. <br />
<br />
The following will give you a date object that represents a date on month prior to the current date:<br />
BirtDateTime.addMonth(new Date(), -1)<br />
<br />
Rob</p></blockquote>
<br />
Hi Rob,<br />
<br />
how to use it to define filename(such as {yyyy}_{mm}) when schedule report in iServer, Thanks.<br />
<br />
Dianbo
averma
Hi Dianbo:<br />
The date-and-time expressions can only be used to provide your desired formatting of date-and-time fields in the document output name. For your custom needs you would write an external application that would generate the output document name and provide it to the iServer (Express) through a web service call. Here are a couple of links that provides details on iServer (Express) web services:<br />
<a class='bbc_url' href='
http://www.birt-exchange.org/wiki/Actuate_Information_Delivery_API/'>Actuate
Information Delivery API - BIRT Wiki - BIRT Exchange</a><br />
<a class='bbc_url' href='
http://www.birt-exchange.org/documentation/Manuals10SP1/using-iserver-integration-tech.pdf'>http://www.birt-exchange.org/documentation/Manuals10SP1/using-iserver-integration-tech.pdf</a><br
/>
<br />
Ashwini