Veelgestelde vragen voor zelfhulp.

Bekijk snel de veelgestelde vragen (en antwoorden) in de standaardlijst. Als u niet kunt vinden wat u zoekt, begin dan met het selecteren van uw Ability Office -versie en verfijn deze dan door zoektekst en/of categorie in te voeren.

Kennisbank artikel 131

Creating filters based on Time

Ability has a single field type for date and time. If you format such a field to display time only and enter values such as 3:30 AM, Database will actually store what it thinks of as a zero date along with the time element. Since dates for Ability start 1st Jan 1990, if you want to create a query based on such a field, it will be necessary to include 1/1/1990.

For example, suppose you have a field called MyTime in MyTable and want to create a filter to include all times after lunch:

  1. Open the table and select Format/Filter.
  2. Enter (MyTable.MyTime > #1/1/1900 12:00 PM#) in the condition box.
  3. Click OK.