<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.3086" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT size=2></FONT> </DIV>
<DIV><SPAN class=603435021-25062007><FONT size=2>Hi all,</FONT></SPAN></DIV>
<DIV><SPAN class=603435021-25062007><FONT size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=603435021-25062007><FONT size=2>is there any variable i can use
to check current time.</FONT></SPAN></DIV>
<DIV><SPAN class=603435021-25062007><FONT size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=603435021-25062007><FONT size=2>I would like to make a query
like:</FONT></SPAN></DIV>
<DIV><SPAN class=603435021-25062007><FONT size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=603435021-25062007><FONT size=2>Query => " Owner
= '__CurrentUser__' AND ( started > '__CurrentTime__' ) AND ( Status =
'open') AND (queue ='test_queue')",</FONT></SPAN></DIV>
<DIV><SPAN class=603435021-25062007><FONT size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=603435021-25062007><FONT size=2>But I dont know the right
variable.</FONT></SPAN></DIV>
<DIV><SPAN class=603435021-25062007><FONT size=2>Actually what Im really
interested in obtain is all tickets opened and not resolved for more than 20
days.</FONT></SPAN></DIV>
<DIV><SPAN class=603435021-25062007><FONT size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=603435021-25062007><FONT size=2>Any hints?</FONT></SPAN></DIV>
<DIV><SPAN class=603435021-25062007><FONT size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=603435021-25062007><FONT size=2>Thanks!</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV align=left><SPAN lang=FR
style="FONT-SIZE: 36pt; COLOR: green; FONT-FAMILY: Webdings; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; mso-ansi-language: FR; mso-fareast-language: ES; mso-bidi-language: AR-SA"><FONT
face="Times New Roman" color=#004080 size=2>Alvaro Muñoz
Sánchez</FONT></SPAN></DIV>
<DIV align=left>
<DIV align=left><SPAN lang=FR
style="FONT-SIZE: 36pt; COLOR: green; FONT-FAMILY: Webdings; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; mso-ansi-language: FR; mso-fareast-language: ES; mso-bidi-language: AR-SA"><FONT
size=2><FONT
face="Times New Roman"></FONT></FONT></SPAN></DIV></DIV></BODY></HTML>