cancel
Showing results for 
Search instead for 
Did you mean: 

How to format date for comparison to property cm_created in Search Options Set?

MG-Moen
Explorer
0 Kudos

I would like to filter a search by document create date but I can't seem to figure out the format that is needed for the comparison to predefined property cm_created in the Search Options Set. 

For example, I want to filter the search by create date greater than 01/01/2000. 

So I tried using dates in various different formats (like mmddyyyyhhmmss, or 01/01/2000 00:00:00)

but none seem to work.  I assume it's because the date format is not correct.

Example:

Predefined Properties(csv):     cm_created(value=01012000000000/operator=GT)

I used other non-date properties for filtering like displayname, and the search results get filtered as expected, so I know that the filtering function is working.

Does anyone know the correct date format to use for comparison?  Thanks!

Accepted Solutions (1)

Accepted Solutions (1)

MG-Moen
Explorer
0 Kudos

Finally figured this out and it is working.

I used the following for Predefined Properties (csv):

Category,cm_created(value=01.01.07 00:00:00/comparator=GT)

and it renders like this;

Answers (0)