Formula workshop – using AND/OR
Using the formula workshop, I am trying to display all records from 10am to 11am that have EITHER data in "field A" OR data in "field B". What is returned are records in the correct time frame (10am-11am), that have data in the "field A", however the records that have no data in "field A" but do in "field B" are not returned. If I switch the order of both these fields then I only get records if there is data in "field B".
Whichever field I place after the OR is not working.
Does anyone have any ideas? Thanks!
Here is the formula with the actual field names:
({Termination_Call_Detail.DateTime} in DateTime (2008, 04, 21, 10, 00, 00) to DateTime (2008, 04, 21, 11, 00, 00))
and
({Termination_Call_Detail.SourceAgentPeripheralNumber} <> ""
or
{Termination_Call_Detail.AgentPeripheralNumber} <> "")
Software/Hardware used:
Software/Hardware used:
ASKED:
April 23, 2008 7:09 PM
UPDATED:
April 24, 2008 1:04 PM
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
