Originally Posted by
davegri
Criteria would be:
Between dateserial(Year(Date()),Month(Date())-1,18) AND dateserial(Year(Date()),Month(Date()),18)
At 19. June this gives the interval at 18. May to 18. June. It must give the interval at 18.June to 18. July!
Code:
DateSerial(Year(Date()),Month(Date())+Iif(Day()<18, -1, 0),18) AND dateserial(Year(Date()),Month(Date())+Iif(Day()<18, 0, 1),18)
or depending how you want to handle 18. day of month
DateSerial(Year(Date()),Month(Date())+Iif(Day()<19, -1, 0),18) AND dateserial(Year(Date()),Month(Date())+Iif(Day()<19, 0, 1),18)