Finding dates and times

To find a date:

• Choose Select > Find or press CTRL-F / CMD-F.
• Click in a date field.
• Type in your find request.
• Press Enter or F3 to perform the find.

Make sure that you use the same formatting in your find request as is used in the field. By default, an exact search is performed and Servoy searches for both date and time.

If you want to search for only a date (without the time component), type a # symbol before your date request.

Null values

A NULL value character ^, representing a NULL (not existing) value, can also be used in your search request.

To perform a find using a range of dates see the section Finding ranges of information.

NOTE: In most SQL databases, an empty value is something different than a NULL value (not existing).