Report Studio - How to calculate [Year To Date Last Year]

[sanchoniathon]

Hi,

I can't seem to find the correct way of calculating (YEAR TO DATE of last year).

Anyone can suggest something ?

Thanks !

[cognostechie]

Try this:

extract(year,[Database Layer].[Date_Dim].[Calendar_Date]    ) = extract(year, current_date) - 1 and
[Database Layer].[Date_Dim].[Calendar_Date]   <= _add_months (  current_date , -12)

[sanchoniathon]

Sorry for the delay but THANK you for your post.

:)