Getting Records for Last Full Year 2003

[steeplec]

I'm having a problem getting records from 2003 to show up on my report. Here is the formula I'm using:

if Month (CurrentDate) = 1 and
{SW_CM_CASE.SWDATECREATED} in LastYearYTD
then 1
else if{SW_CM_CASE.SWDATECREATED} in YearToDate
then 1
else 0

What I want to do is if the date is Jan 2004 I want to count records opened and year to date from the previous month for Dec 2003. If the month is Feb 2004, I want to count cases for Jan 2004.

Please help if anyone has any ideas on how to get around this.

Thanks.

 

[synapsevampire]

I think that I answered your other post.

-k