{?startdate} >= dateadd("yyyy",-1,{tdate})
and
{?enddate} <= dateadd("yyyy",-1,{tdate})
would replicate the formula above.
{?startdate} >= dateadd("ww",-52,{tdate})
and
{?enddate} <= dateadd("ww",-52,{tdate})
Would return the same day of the week a year ago.
However I assume your startdate occurs before your enddate? The above formulas wouldn't return any entries as you're asking for a return where the transaction date is before the startdate and after the enddate.
dateadd("ww",-52,{tdate}) >= {?startdate}
and
dateadd("ww",-52,{tdate}) <= {?enddate}
Would return everything between the start and end date.
Regards,
Ryan.
Edited by rkrowland - 30 Jan 2012 at 12:08am
IP Logged
