Re: F45, how to query a date(time) column with just the date?
From: Sean McMurray <smcmurr_at_xmission.com>
Date: Fri, 02 Jul 1999 12:10:03 -0700
Message-ID: <377D0E8B.88CF6614_at_xmission.com>
Date: Fri, 02 Jul 1999 12:10:03 -0700
Message-ID: <377D0E8B.88CF6614_at_xmission.com>
Andy Hardy wrote:
> Hi,
>
> I have a table which includes a date column.
>
> 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?
Two thoughts. I don't know if either will work but, here you go.
- What if the user enters 10-JAN-1998%
- What if you separated the action date into two differenct items, one with a format mask that showed the date, the other with a format mask to show time. Could you query on it then?