That might work for the forward end, but I'm looking for the past. In other words the list of people who's warranty is about to expire. I thank you for your help but I figured out what I needed to do on my own.
All I did was put the todays date back into numberical order by (year,month,date) using the left and mid function multiplying each by the appropriate value
2004 * 10000.00
12 * 100.00
31
and added them together. and it worked
HERE IS THE CODING:
(ToNumber (Mid (ToText(currentdate), 7, 4)) * 10000) + (ToNumber (Left (totext(CurrentDate), 2)) * 100) + (ToNumber (Mid (totext(currentdate), 4, 2)))
this formula takes out the "/" and puts it in value of 20041231.00 (yyyy,mm,dd)
Once again I thank you for your time.