Even though my range is for 13 months with the WHERE:
When I look at the details I'm only seeing 6/1/2013 to current day.Code:PaymentDate = Between IIf(Month(Date())<=5,DateSerial(Year(Date())-1,5,1),DateSerial(Year(Date()),5,1)) And IIf(Month(Date())<=5,DateSerial(Year(Date()),5,30),DateSerial(Year(Date())+1,5,30)))
I know there is data for May 2013.
What is wrong with my criteria?