<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; color: rgb(0, 0, 0); font-size: 14px; font-family: Calibri, sans-serif; ">
<div>
<div>
<div>Hi. I've found quite a few examples and documentation about using relative dates to search RT; however, for the life of me, I can't figure out how to use relative dates to get a list of tickets that were created last month.</div>
<div><br>
</div>
<div>I would like to create and save a search for our secretary, so she can easily get a list of tickets in a specific queue that were created last month. Without using relative dates, getting the tickets in this queue that were created last month is not a
problem. This works perfect.</div>
<div><br>
</div>
<div>Queue = 'Root Cause Analysis Forms' AND ( Created >= '07-01-2011' AND Created < '08-01-2011' )</div>
<div><br>
</div>
<div>Using relative dates, I tried these, and none work how I want.</div>
<div># This works, but the end date isn't relative</div>
<div>Queue = 'Root Cause Analysis Forms' AND ( Created >= 'first of last month' AND Created < '08-01-2011' )</div>
<div><br>
</div>
<div># Returns 0 results</div>
<div>Queue = 'Root Cause Analysis Forms' AND ( Created >= 'first of last month' AND Created < 'first of this month' )</div>
<div><br>
</div>
<div># Returns 0 results</div>
<div>Queue = 'Root Cause Analysis Forms' AND ( Created >= 'first of last month' AND Created < 'first of the month' )</div>
<div><br>
</div>
<div># Returns 0 results</div>
<div>Queue = 'Root Cause Analysis Forms' AND ( Created >= 'first of last month' AND Created < 'this month' )</div>
<div><br>
</div>
<div>#Returns 0 results</div>
<div>Queue = 'Root Cause Analysis Forms' AND ( Created >= 'first of last month' AND Created <= 'end of last month' )</div>
<div><br>
</div>
<div><br>
</div>
<div>Any help appreciated.</div>
<div><br>
</div>
<div>Thanks</div>
<div>John</div>
<div><br>
</div>
<div>
<div></div>
</div>
</div>
</div>
</body>
</html>