On Oct 17, 2006, at 11:51 AM, Youri wrote:
Hi,
I need to develop an Agenda (very common sorry), but it will have
to answer to some simple questions for a human, such as :
What is the 1st possibility for my patient to get an appointement?
(find the 1st possible date)
My patient can only come on Fridays, what is the 1st possible date
of appointment?
...
It is mainly a quick and dirty way to "optimize" an agenda for a
Doctor.
The agenda will be based on a DB.
Any suggestion will be apreciated.
Depending on how your schedule is set up in the DB then you will have
different possibilities
Say you know that an appointment should be booked in 15 minute
increments
So then if the patient only wants to come on a friday find the first
open 15 minute time slot on a friday
I can't write an SQL statement for this without knowing what your
database looks like
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
