Searching for Current Date cases only

[ddrake]

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

 

[ddrake]

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!

 

[Parkypark]

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

 

[airon]

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)

 

[ddrake]

Try this one:

'Create Date' >= $DATE$