Ignore, I figured it out, it took 18 million ()'s, unless you have a better idea?
I have a complex scenario as follows which is used to set a textbox picklist using F2RefTable.
Condition1. All record must meet two condition (Fld1 = 1 .AND> FLd2 = 1)
(Fld3 and Fld4 are dates and I need to select records based on dMyDate
dMyDate is never blank.
After the above, all of the following to qualify
Contidion 2 Both dBeg 3 and dEnd 4 can be Blank
Condition 3 OR dEnd4 is blank and dMyDate >= dBeg
Condition 4 OR dBeg is blank and dMVDate <= dEnd
Condition 5 OR between(dMyDate, dBeg, dEnd)
IF include records where both dates (dBeg and dEnd) are blank
AND include records where the dBeg <= dMyDate and the dEnd date is blank
And include records where the dEnd >= dMyDate and the dBeg date is blank
And include records where dMyDate is between dBeg and dEnd.
Condition1 must be met and any record that meets Condition2 thru 4 are to be included.
I can't seem to get the logic to work. Probably has to do with the location of parentheses.