I'm trying to get a query to list insurance policies that will expire in 30 days. What criteria do I use? I used: <Now()+30 And >Now()
This listed policies that will expire on August 3rd and August 4th and also listed policies that will expire on July 10th. I only want a list of policies that will expire 30 days from today. Why did it list the policies that will expire in five days? What criteria do I use to get a list of policies that will expire in 30 days?