Searching/Filtering through Dates and Numbers
How can I search a date range?
When I index a date column I get a value like 011895696000000. From previous posts I know how to display it as a date. However, how can you search with a date range on it?
Apparently I can't search based on a particular column either. For example: a Query like: 'MyColumn1: Books' gives me no results. But of course just Books will return results although I can't restrict the term to the field MyColumn1.
To search on a date or numeric range, do I have to normalize the field? I.e, for Numbers - convert 1.234, 10.56 to 01.234 and 10.560)? and for Dates - convert 7/19/2007, 7/20/07 to 2007-07-19 and 2007-07-20 even though the field is Date/Time?
I've tried all possibilities - ColumnName: (Term), ColumnName: Term, MyDate: 07-20-2007, MyDate: 07/20/2007, MyDate: 2007-07-20, MyDate: 20070720 (with and without parenthesis). None worked.