about dates in Base

English
,
#1

hi all. i’m dealing with base to create some application to able to reserve/book services at my company. i can’t figure out how to check available times. I will be glad of any help

#2

Your question is quite vague. It opens with Dates in Base yet asks about available times. You don’t state if you’re looking to check a time field or timestamp field. In any case, without more information, you are probably looking at SQL. It’s also a guess here that you are dealing with Libre Base as delivered, meaning you are using HSQLDB - the included database. Information using Date/Time functions in HSQLDB can be found in the manual in Chapter 10. A PDF version of the guide can be obtained at this link.

#3

In the future please EDIT your original question (or use comment) to provide additional information.

The scenario you present seems to need some design work for your database. On the surface, one table for customers, one for services, one for employees and another for their schedule. Then it’s a matter of which employee has a time slot open to perform the service. Your question is not so much how to check for times as it is how to design the system - too much for a forum question.

#4

Thanks,
I had already designed base (generally like your recomendation) + apropriate forms,
now i thinking about time slot checking implementation.
i think to use UNIX_TIMESTAMP function for this purpose
thanks again :slight_smile:

#5

thanks for reply,
i will explain business process in my company:

  1. We have few services - service_a, service_b and so on. This services have their execution times.
  2. We have few persons/employees to perform this services - person_a, person_b and so on.
  3. we have also have one person/employee to manage/administer other employees and services execution process and some other tasks - let’s name it manager :slight_smile:
  4. to receive service, customer must reserve/book it by web form, mail or by phone. manager must register this requests in database application.
  5. database application must be able to check availability of persons/employees (person_a,person_b …) and do not allow time overlaps between service execution times.

sorry for my poor English,
i guess general things is clear :slight_smile:

thanks again

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.