Previous Full Year Date Range Formula

[pcollins1]

I need a Formula that will calculate the previous full year date range of 01/01/year to 12/31/year. My formula is:

if {Table.date}>=dateadd{"yyyy",-1,#2006/1/1} and {Table.date}<=dateadd{"yyyy",-1,#2006/12/31} then {Table.qty}

I do not want to have to key in the dates in the formula, but I have not found a way to just look at todays year range and subtract 1. Something like LastYearYTD formula, but only for the previous year Jan 1 to Dec 31 not up to today.

 

[lbass]

You could use:

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

-LB

 

[pcollins1]

Thanks, That worked.