Hi folks

A tip (more like an observation really)

LIST AND SEARCH TYPE

In one Search & List Type I have two fields

1. scheduled_time
2. attendend_time

MODULES

I have 2 modules

1. Scheduled (future appointments)
2. Attended (appointments attended already)

• To get the whole thing working correctly I noticed that I had to place my live value in the module, rather than in my Search Form.
• In the Scheduled module the field "attended_time" is set to "clear"
• In the Attended module the field "scheduled_time" is set to "clear"

MATCH

My Match (3) settings..

1. "scheduled_time" -> Future (> or =)
2. "attendend_time" -> Past (< or =)

Note: At this point, neither field shows in my search when I debug.

LIVE

Now, I want to set the time to Match against as "now".

• If I place the live value (2) as "now" for both fields in the search form then both fields will show up in the search irrespective of the modules setting. 
• In other words, it ignores the "clear" setting I applied in the module. 
• In Scheduled, "attendend_time" shows even though it is set to clear
• In Attended, "scheduled_time" shows even though it is set to clear

SOLUTION

Place "now" in the module's Live options 

ORDERING

I also placed ordering in module, too using the option "Custom":

1. "scheduled_time" ASC
2. "attended_time" DESC

Hope that helps someone else out there at some point