Problem in querying date of one week

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