Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Searching for Current Date cases only

Status
Not open for further replies.

ddrake

Technical User
Mar 19, 2003
92
Hi!
I am creating macros that will (hopefully) select all cases created today and for a particular Assigned To Group. I am passing that dataset on to a Crystal template I threw together to display the results.
My dillemma is how do I word the syntax of the advanced search string to select only cases created today?

Thanks!!
Dave [pc3]
 
Nevermind...found it! [2thumbsup]

The solution lies in using the keyword $DATE$. So, in this example, to find all cases created today, I put in 'Create Time' >= $DATE$. Works great!
 
The $DATE$ keyword = The current date @ midnight (00:00:00)
so
'Create Time' >= $DATE$ will indeed show all records logged after midnight today.
 
I am trying to use the above date function in a search in remedy version 5.01.02, should this work in this version.
I am getting the following error:

Unknown field referenced in search line.: position 13 ('Create Time'^ >= $DATE$) (ARERR 1587)
 
Try this one:

'Create Date' >= $DATE$
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top