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

    How to create a search based on the system date

      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