Need help with search

[PureMoxie]

I'm having trouble figuring out the indenting for the following "Due Soon" search. I'll write it as I would in SQL.

(Due Date <= 2 weeks from today AND Due Date > today) OR (Begin Date <= 2 weeks from today AND Begin Date > today) AND Flag != Completed

Also, perhaps in a future version we could have an Advanced-Advanced search where we can just enter queries directly?

[kevina]

I assume you really intend this:

((Due Date <= 2 weeks from today AND Due Date > today) OR (Begin Date <= 2 weeks from today AND Begin Date > today)) AND Flag != Completed

This is slightly different than what you specified (the extra parentheses make the Flag criteria always required and only on of the other expressions). If so, below is how you would define the Advanced Search:

Flag != Completed
    AND DueDate <= #2 weeks from today#
    AND DueDate > #today#
        OR BeginDate <= #2 weeks from today#
        AND Begin Date > #today#

[dasymington]

Originally posted by PureMoxie
Also, perhaps in a future version we could have an Advanced-Advanced search where we can just enter queries directly?

Yes, I'd like that. I can quickly think of how I'd write a query but it takes a bit of time working out the indents needed in Ultra Recall. This is one area where UR is not easy to use.