F45, how to query a date(time) column with just the date?

[Quoted] [Quoted] I have a table which includes a date column.

[Quoted] I would like the user to be able to query this table using this date, but I don't want them to have to enter the time part of the date. Instead, I want all records for that 'date' to be retrieved.

The form is to be based on the table.

E.G.

PK action_date action_type

key1, 10-JAN-1998 02:14, 1
key2, 10-JAN-1998 12:10, 1
key3, 10-JAN-1998 22:14, 1
key4, 11-JAN-1998 02:14, 1

When in query mode, the user enters 10-JAN-1998 in action_date and enters 1 in action_type. The first three records should be retrieved.

Any thoughts?

-- 
Andy Hardy. PGP key available on request
===============================================================