- Joined
- Sep 23, 2005
- Messages
- 2
- Reaction score
- 0
Hi,
Can anyone help with a date problem which sounds simple to do?
I have a "warranty expires" field in a query and would like to be warned 30 days prior to it arriving. I've tried. Warning Date: [warranty expires]-30 which gives me the date 30 days before, but I want to run the query to check all expiring warranty's from current date so a person enters todays date and any expiring warranty's within 30 days will show.
Very new to access and would appreciate some help.
Steve
Can anyone help with a date problem which sounds simple to do?
I have a "warranty expires" field in a query and would like to be warned 30 days prior to it arriving. I've tried. Warning Date: [warranty expires]-30 which gives me the date 30 days before, but I want to run the query to check all expiring warranty's from current date so a person enters todays date and any expiring warranty's within 30 days will show.
Very new to access and would appreciate some help.
Steve