We have a scoreboard query request for a listing of all completed change order WF tasks for the last month but I need to make certain that it shows all of last months' (even if I run the query on lets say the 10th of the following month). I was going to experiment with the PAST_MONTH but it won't accept the syntax below. Any help would be appreciated.
group.[group]group_list.member IN (@cnt.id) AND EndAtTime(\'PAST_MONTH\') AND status = \'COMPLETE\'