Hi Guys,
I was trying to create a qeury which returns all open tickets whose
"Proposed Start Date" are in this week, from specific queue. I tried with
some build-in variables in searching as showing below:
Queue = ‘ChangeRequest’ AND ( Status != ‘rejected’ AND Status !=
‘resolved’ ) AND ‘CF.{Proposed Start Time}’ > ‘last Sunday’ AND
’CF.{Proposed Start Time}’ < ‘Sunday’
but this query returns nothing. BTW, “Proposed Start Time” is a datetime
custom field applied to this queue.
Can anyone please help to check on this, see whether it doesn’t work? Many
thanks.
Br
Vodar