2 Replies Latest reply: Jun 15, 2012 10:28 AM by Dwayne Dorsey RSS

How to create a search based on the system date

Dwayne Dorsey

I was trying to create my own Search but could not find the function that will select only the system date when the search is ran i.e.

 

If I run the search today the results I’m looking for is

 

All of the tickets submitted by me on June 14, 2012

 

Based on my reading I would have to change the date for each day the search is executed.

 

In some SQL systems using today() will display the system date. I could not find the same function in Remedy.  I found the keyword of $DATE$ but results of the functions does not give the system date but the date the search was created.  I created the search yesterday and the data was for June 13, 2012 but when I ran the search today it gave the same information is received yesterday

 

Any help would be welcomed

 

Thanks