datetime problem

Hi everyone!

I am a beginning ASP programmer and I am trying to use the datetime function. I am using Access as my backend database if you are wondering. I am building a program where someone can keep track of the software in our department and she wanted it to be able to email her when the software has been checked out for over 7 days. Does anyone know how to do this or where I begin? I am not too familiar with how one would add to dates in ASP.

Thanks in advance!

Well, as for tracking software that would be pretty simple.

Create table in access with all of the fields you want to store values for, including a date field that stores when the software was checked out.

Create a form where users can fill in values and an ASP script to insert those values into the database.

Create a listing page that will show all of the checked out software.

It would be difficult to automatically email her, however you could sort the list by items that have been checked out the longest, maybe eve use the dateDif function to calculate how many days it has been checked out and she could check that list each morning.

If this sounds complicated then I would recommend a good book and some simple practice applications before tackling this.

Let me know if there are any more specific questions that I can answer.