>>This kind of logic should work.
>>
>>IF BETWEEN(12, DAY(PpBeg), DAY(PpEnd))
>> *--Select the rec.
>>ENDIF
>>
>>-Matt
>
>Won't work if the pay period spans across 2 months (last week of month, 1st week of next month). BETWEEN must have the smaller comparison number first.
>
>
>
>Update:
>
>No, that wouldn't work, either. Say the dates for the pay period are 6/20 to 7/4. The 12th isn't between those 2 dates.
It wouldn't find what it wasn't supposed to find - which is just what was required. I also first thought this was wrong, but it's actually right. So if neither 6/12 nor 7/12 is between 6/20 and 7/4, good, don't include that period.