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\'
you can try
group.[group]group_list.member IN (@cnt.id) AND completion_date < EndAtTime(\'PAST_MONTH\') AND status = \'COMP\'
Thank you very much! I put the query in and seem to be getting all past Completed tasks which for Role I am creating this for could end up being a lot to go through. Is there possibly a way to just pull the last 45 days?
Jessie, I think it is possible with a custom time stamp...you could copy the PAST_MONTH and modify it and then use
the new one instead of PAST_MONTH. By the way, the query should be modified to as
group.[group]group_list.member IN (@cnt.id) AND completion_date > StartAtTime(\'PAST_MONTH\') AND completion_date < EndAtTime(\'PAST_MONTH\') AND status = \'COMP\'
The one I suggested before returns all complete tasks before this month, not only last month's
Thank you very much, I did a copy and made it for the last 45 days under the timespans and called it correctly in the query.