Found a post from Cognos 8, but it won't work in Cognos 11. I'm looking to compare prior YTD data with current YTD data. Here is what I found, but this does not work when I try it. Any help would be appreciated! : 

Current YTD Sales:
if ( SalesDate between _make_timestamp(extract(year,current_date), 1, 1) and current_date )
then (SalesAmount)
else (0)

Prior YTD Sales:
if ( SalesDate between _make_timestamp((extract(year,current_date)-1), 1, 1) and _add_years(current_date,-1) )
then (SalesAmount)
else (0)

Thank you for your review!

------------------------------
Heather
------------------------------

#CognosAnalyticswithWatson

Nevermind, was able to resolve, this is the correct format

Current YTD:
if ( [SalesDate between _make_timestamp(extract(year,current_date), 1, 1) and _add_years(current_date))
then ([SalesAmount])
else (0)

Prior YTD:
if ( [SalesDate] between _make_timestamp((extract(year,current_date)-1), 1, 1) and _add_years(current_date,-1) )
then ([SalesAmount])
else (0)

------------------------------
Heather
------------------------------