FAQ

Domande frequenti per l'auto-aiuto.

Si prega di dare una rapida occhiata alle domande (e risposte) comuni nell'elenco predefinito. Se non riesci a trovare quello che stai cercando, inizia selezionando la tua versione di Ability Office e poi restringila inserendo il testo di ricerca e/o la categoria.

Articolo della base di conoscenza 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.