Re: Query Range of Dates in Forms
Date: Thu, 27 Aug 1998 15:20:56 GMT
Message-ID: <6s3tgo$fek$1_at_nnrp1.dejanews.com>
In article <35E4ABB1.E22275CB_at_mindspring.com>,
jenningse_at_mindspring.com wrote:
> I have a date field in a FORM. Sometimes the user wants
> to query a range of dates, as opposed to a particular date.
> How can this be done. The users have no knowledge of SQL, and
> couldn't construct an 'AND' clause if their life depended on it.
> What they would like to enter is something like:
>
> 15-AUG-98..18-AUG-98
>
> The FORM needs to be smart enough to recognize a single date or
> a range of dates. Anyone know how this can be done without
> introducing a second date field?
Not in Forms. I would introduce a second field, but not a date field. Make it a text field that your user can enter the date range in, then write pl/sql code to parse the two dates and the '..' to set the actual where clause. Not a simple task... good luck.
Steve Cosner
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Aug 27 1998 - 17:20:56 CEST