Calculating number records created in year to date by month 1

[IanGurman]

I am trying to create a filter that will return dates in any given year since the first of the year. I do not want to use a prompt as the report is to be scheduled. As the schedule needs to run next year as well as this I want the filter to work for the current year whatever the year. Can anyone help with a Cognos 8 function or syntax to acheive this

 

[blom0344]

extract(year,[some_date]) = extract(year,current_date)

where some_date references the date you use from either dimension or fact.

Ties Blom