Calculating a Date in a List Box

  • Thread starter Thread starter Dale
  • Start date Start date
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.
 
Dale,
The WarrEndDate criteria would be...
Between Date() And DateAdd("m",+1,Date())
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Formula - Count Dates from another Sheet 8
Calculating Dates: 5
Another Date ? 21
Arithmatic on Dates 2
Text in a Text Box 1
list box remove item 1
Another Date ? Continued 1
Date Calculation 4

Back
Top