>>>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.
That's true, but I think it's right for the wrong reason. It all depends on what constitutes a pay period, I'd think. BETWEEN wouldn't find it if it was 6/30 to 7/13 either, in which case it would NOT be right that it wasn't found.