Search Expression for Between Timestamps

[bnichol]

I'm trying to select the results between 2 timestamps in a multibox using the search expression.

I'm able to accomplish something similar for dates, by providing ">=2010-07-01 <2010-08-01".

When I try this with timestamps, there is no reduction in the result set.

Any suggestions?

B

[#2]

Check your DateFormat. It should be like this:

SET DateFormat='M/D/YYYY';

And type the date in this format for your search expression.