Calculating a Date in a List Box

D

Dale

I need some help from the group. I have a table with a field that contains
the warranty expiration date for each item. I would like to display in a
list box All those items whose warranty will expire over the next 30 days.
I need help in developing the function I would put in the criteria section
of the underlying list box query. Thanks in advance.
 
A

Al Camp

Dale,
The WarrEndDate criteria would be...
Between Date() And DateAdd("m",+1,Date())
 
Top