Formula for LastYearYTD and LastYear(all) Sales Figures

[jagmb5555]

If I use lastyearYTD formulas, it relies on system date or Report SET DATE & TIME. I need to be able to use a Parameter defined date to measure Current Year To Date and Last Year To Date vs System Date or Set Date.

 

[kskid]

Try this.

Given a date parameter {?Parmdt}, then

(
{table.date} in dateserial(year({?ParmDt}-1),1,1) to dateserial(year({?ParmDt}-1),month({?ParmDt}),day({?ParmDt})) or
{Table.date} in dateserial(year({?parmDt}),1,1) to {?parmDt}
)

The beauty of this is that it does not require a formula and the Show SQL Query will show the dates in your record selection

Cheers,
-LW