<div>
Is it a hard coded filter or dynamic?<br />
If hard coded, you can simply create a data item called 'Custom Year' with expression like below and use it for date filter:<br />
Date between 10/1/2012 and 10/1/2013<br />
<br />
For dynamic/rolling, you have to create calculated data items depending upon how many years you want users to see for data selection.
</div>


Is it a hard coded filter or dynamic?
If hard coded, you can simply create a data item called 'Custom Year' with expression like below and use it for date filter:
Date between 10/1/2012 and 10/1/2013

For dynamic/rolling, you have to create calculated data items depending upon how many years you want users to see for data selection.

<div>
I am looking for calculated data item for one year.. can you please let me know how to create a calculated expression for this...
</div>


I am looking for calculated data item for one year.. can you please let me know how to create a calculated expression for this...

<div>
if ([Date Field] is between 2012-10-01 and 2013-10-31) then ('Current Fiscal Year') else null<br />
<br />
That should work. Give it a try.<br />
You may have to cast your date field if it's not in yyyy-mm-dd format.<br />
If it doesn't work, I'll test at work on Monday and follow up.
</div>


if ([Date Field] is between 2012-10-01 and 2013-10-31) then ('Current Fiscal Year') else null

That should work. Give it a try.
You may have to cast your date field if it's not in yyyy-mm-dd format.
If it doesn't work, I'll test at work on Monday and follow up.

<div>
The above one is like hard-coding the dates right, I need help for automatic one like below where I am using for Quarterly data.<br />
<br />
_first_of_month(_add_month<wbr />s(current_<wbr />date,-3))
</div>


The above one is like hard-coding the dates right, I need help for automatic one like below where I am using for Quarterly data.

_first_of_month(_add_months(current_date,-3))

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
Can anyone please help me on how to write an automatic expression for yearly date filter.<br />
<br />
Year &nbsp;tarts from OCTOBER . For example &nbsp;OCTOBER 2012 - OCTOBER 2013 is an year
</div>
</div>


Hi,

Can anyone please help me on how to write an automatic expression for yearly date filter.

Year  tarts from OCTOBER . For example  OCTOBER 2012 - OCTOBER 2013 is an year

Yearly Date expression in cognos

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.