Date range -- Year to date until last Sunday 1

[willz99ta]

Hi and thanks for your help,

I am trying to figure out how to select the date range from my report to be the Year To Date until last Sunday.

Any idea?

Thanks again,
Will

 

[lbass]

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

This would be through the previous Saturday. If you want to include Sunday, add +1 at the end.

-LB

 

[willz99ta]

Guitar Hero Voice -- YOU ROCK