Log in expiry dates
I am setting up a 'concierge' system for a holiday location to allow guests to order food, wine etc.
I have set up a table called 'Guests' with GuestID, GuestUserName, GuestPassword, GuestArrival and GuestDepart.
What I would like to do is only allow their log in details to work between their check in (GuestArrival) and check out (GuestDepart) dates.
I have set up the standard login page with Username and Password which works, but I'm not sure about getting the dates to work.
If it is going to be too complex to do a date range, then I would like at the very least to be able to make the log in expire so that they cannot order stuff after they have left.