jtarabay
Posts: 13
|
| Posted: 09/15/2006, 5:47 AM |
|
I have an access database which I am using ASP to run searches and generate reports of data. One of the pages is an expirations page. It is used to run a search on the database for expiring dates. There are about 10 expirations dates. Each one has its on search. The issues is that they don't want to search by the exact date, just the month and year since something expiring that month is what they want to know. So they might type in 9/2006 and they would want the report to indicate anything expiring in 9/2006 regardless of the day. In the database, the dates are formatted like this m/d/yyyy and then sometimes like this mm/dd/yyyy depending on the month and the day. There is too much data to go in and make them all mm/dd/yyyy. Can anyone help me with how to make the search program search in the way I have described? Thank you very much.
|
 |
 |
|
