Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Searching for Current Date cases only

Searching for Current Date cases only

Searching for Current Date cases only

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?


RE: Searching for Current Date cases only

Nevermind...found it!  

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!

RE: Searching for Current Date cases only

The $DATE$ keyword = The current date @ midnight (00:00:00)
'Create Time' >= $DATE$ will indeed show all records logged after midnight today.

RE: Searching for Current Date cases only

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)

RE: Searching for Current Date cases only

Try this one:

'Create Date' >= $DATE$

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close