Jump to content
Sign in to follow this  
nick_jp

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

Recommended Posts

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.

Share this post


Link to post
Share on other sites

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]

Share this post


Link to post
Share on other sites

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

Anyway your suggestion works. TVM!

Share this post


Link to post
Share on other sites

I split the topic.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.