Frequently asked questions for self help.
Knowledge base article 131Creating 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:
- Open the table and select Format/Filter.
- Enter (MyTable.MyTime > #1/1/1900 12:00 PM#) in the condition box.
- Click OK.