If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Extract Year from Date Field

Started by gatorfe, 06 Jan 2014 02:42:14 PM

Previous topic - Next topic

gatorfe

We have a filter on a simple list report to always show the current year data on sales orders coming in.  This is the formula we have on the filter of the list report [Order].[Year] = extract(year,current_date).  This should give us 2014 but now is given us 1 instead.  What do we need to do to show us 2014?  The field is setup as an integer in our sql dw.  Thanks in advance for any suggestions.

HDA

Try this...  [Order].[Year] = year(current_date)