I am trying out dtSearch and cannot make heads and tails out of how to search for a date range.
This index is just a large collection of MSG messages with "DeliveredDate" indexed.
I have tried
alpha and beta and gamma and DeliveredDate(20100101~~20100505)
alpha and beta and gamma and DeliveredDate(Y2010/M01/D01~~Y2010/M05/D05)
What am I doing wrong? How can one search for a date range on one of the returned columns?
jhup, I know that you can do a numeric range like dog w/10 of 12~~15. That would give you one of the numbers 12 through 15 within 10 words of dog. I think you may want to try the date like 20100105~~20100210. This might work…. Hope this helps in some way.
Thanks.
I figured it out.
If it is one of the fields that was automagically recognized then the construct is
alpha and beta and gamma and (DeliveredDate contains date(2010/01/01 to 2010/05/05))
I was not aware of the date() part. The ~~ would work too instead of the "to". It also works with "Jan 1 2010" or variation thereof.
I think I am going to have to index the help of this tool just to grasp it… wink
Anyone else use dtSearch with the Reporting or Exporting wizard?
Can the data be separated, and can the export not include the originals?