FAQ

Foire aux questions pour l'auto-assistance.

Veuillez jeter un coup d'œil aux questions (et réponses) courantes dans la liste par défaut. Si vous ne trouvez pas ce que vous cherchez, commencez par sélectionner votre version Ability Office , puis affinez-la en saisissant le texte de recherche et/ou la catégorie.

Article de la base de connaissances 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.