Smart Search Filtering by Date

I recall date time filters can be a bit of a pain. First use LUKE 4.0 to check your index, for mine the "documentcreatedwhen" time field is in the format yyyymmddhhmmss, your filter only has yyyymmddhhmm, so you may need to add the seconds on there. It's doing less of an integer search and more of a text search i believe.

Try that, use Luke 4.0 to do your own search parameters on your index first to see if you can get the syntax right, then apply to the filter.

https://code.google.com/archive/p/luke/downloads

The syntax is correct. Did you assign Date Field in your page type/search fields?

_created is matching Date Field (New Release Date) on the picture

Thanks Peter and Trevor

I got it working the end by adding brackets

+_created:([20170101000000 TO 20171231235959])

I think as Trevor suggested the search preview was doing more of a text search before.

Appreciate your help with this

Tracey

I missed the fact that your put ; instead of : in your first post. Date search in Lucene is inclusive. So you can do +_created:[20170101 TO 20180101] to search of entire 2017, you don't need seconds and parentheses.