Need filter help

The place for peer-to-peer support for VPM Enterprise 9.1, our latest framework.

Need filter help

Postby btiguy » Fri May 15, 2015 1:06 pm

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.
TIA
Don
btiguy
 
Posts: 455
Joined: Mon Jun 21, 2010 4:03 pm

Return to VPM Enterprise 9.1

Who is online

Users browsing this forum: No registered users and 1 guest

cron