
December 9th, 2003, 03:55 PM
|
|
Registered User
|
|
Join Date: Dec 2003
Posts: 8
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
using datestamp?
Hi,
I am trying to do a little library script, where a user can search for a book, and then book it out for 1 month.
All is well, exept I don't know how to make the script to start the booking at todays date and to last for one month and then clear from the bookings table.
I use an Access database.
What column should I have in my database?
should it use datestamp for when the booking is make and then have another column with datestamp + 31 days or something?
How can I do that?
what should I add to my insert records sql?
I don't have a clue here.
Can you help?
Thanks,
Vinny
|