Current Year and Last Year

[aj3221]

I have a report that has a year field that I am pulling from our system. I want to pull the current year and one year ago (17 and 16). Every year I have to go in and add the current year and get rid of of date 2 years ago. For example, at the beginning of 2017, I had to go in and remove 15 (for 2015) and add 17 (for 2017). Is there a way to just have it look at the current year and then 1 year ago so I don't have to go in and add the current year and take out the oldest year?

 

[lbass]

Use a record selection formula like this:

{table.date} in date(year(currentdate)-1,1,1) to date(year(currentdate),12,31)

If instead you have a year field with two digits only, try this:

(
{table.year}=Right(totext(year(currentdate)-1,"0000"),2) or
{table.year}=right(totext(year(currentdate),"0000"),2)
)

-LB