
March 15, 2010 18:23 by
Create a string parameter with the options you want. eg. lastFullWeek, lastFullMonth, YearToDate, etc...
then add a switch statement in the record selection formula editor like below
{@Post Date} in
Switch
(
{?Period} = "Yesterday",
(currentdate - 1) To currentdate -1,
{?Period} = "LastWeek",
Minimum(LastFullWeek) To maximum(LastFullWeek),
{?Period} = "LastMonth",
Minimum(LastFullMonth) To maximum(LastFullMonth),
True, // provide default handling and specify a valid range
CDate(2009, 12, 30) To CDate(2009, 12, 30)
) and
47ed8bf2-0b75-4ddd-90b1-95bc27468d99|0|.0