FAQ

Vanliga frågor för självhjälp.

Ta en snabb titt på vanliga frågor (och svar) i standardlistan. Om du inte hittar det du letar efter, börja med att välja din Ability Office version och sedan begränsa den genom att ange söktext och/eller kategori.

Kunskapsbasartikel 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.