Search for all records between (inclusive) two time fields.

[nick_jp]

I'm trying to search for all records between (inclusive) two time fields.

Two other fields are included in the search; date and userId.

I'm finding that the date and userId filter out other records correctly, but the time range filter doesn't.

Filter is: Set Field [EventRecords::Event_Time; "Events::gEventStartTime...Events::gEventEndTime"]

Any ideas? Event_Time field is indexed.

[Ender]

I'm not sure why this isn't in it's own thread, but I'd say check your syntax. Maybe:

Set Field [EventRecords::Event_Time ; Events::gEventStartTime & "..." & Events::gEventEndTime]

[nick_jp]

I thought it was related... on review I guess it's not. Apologies for that.

Anyway your suggestion works. TVM!

[Lee Smith]

I split the topic.