We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

about dates in Base

asked 2016-04-17 01:14:13 +0200

levglonti gravatar image

updated 2021-05-27 14:07:57 +0200

Alex Kemp gravatar image

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

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2016-04-17 20:39:35 +0200

levglonti gravatar image

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 :)
  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 :)

thanks again

edit flag offensive delete link more

answered 2016-04-17 14:58:31 +0200

Ratslinger gravatar image

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.

edit flag offensive delete link more


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.

Ratslinger gravatar imageRatslinger ( 2016-04-17 21:10:50 +0200 )edit

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 :)

levglonti gravatar imagelevglonti ( 2016-04-18 00:28:07 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-04-17 01:14:13 +0200

Seen: 99 times

Last updated: Apr 17 '16