KNOWLEDGE BASE
Log In    |    Knowledge Base    |    4D Home
Tech Note: Storing and Searching for Available Times in a Schedule
PRODUCT: 4D | VERSION: 6.0 | PLATFORM: Mac & Win
Published On: January 1, 2000
Your current browser may not allow you to download the asset. We recommend Mozilla Firefox or Google Chrome.
Log In

Imagine that someone comes to you with the following database requirements: In a doctors' office, the program will keep track of appointments for each of the doctors. Each doctor’s days are divided into 10 minute units. For example, Dr. Kramer has an appointment from 9:30 to 9:50 with Shana F., followed by an appointment with Frank D. from 9:50 to 10:10, and so on. They want to be able to do searches for unscheduled time that fit certain criteria such as: What is the next 50 minute opening after 3 pm?

This tech note covers a simple yet flexible approach for handling this problem.

Tech Note