AnsweredAssumed Answered

Syntax Completed CHG WF Tasks Last Month

Question asked by jlhawley on Nov 13, 2018
Latest reply on Nov 14, 2018 by jlhawley

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\'

Outcomes