WPW07 wrote:
> On Feb 28, 10:51 am, Captain Paralytic <paul_laut...@yahoo.com> wrote:
>> On 28 Feb, 15:18, WPW07 <wwisnie...@gmail.com> wrote:
>> > I thought it was working fine until I ran into a problem. The SQL
>> > statement doesn't work if I want to see only those tasks begun and
>> > completed on the same day. For example, I entered begin_date
>> > 02/22/08 to end_date 02/22/08 because I only want to see tasks
>> > started AND completed on that date. But my SQL is set up (with the
>> > "OR") so that it's returning tasks with a begin_date of 02/21/08
>> > and end_date of 02/22/08.
>>
> Thank you for your reply. I did try WHERE begindate = x AND enddate =
> x But the problem is that if there isn't task that meets those exact
> data parameters nothing gets returned, where as if the begin date is
> between x and y and the end date is between x and y, results do get
> returned.
If you read my post properly you will see that I acknowledged that this
obviously wasn't going to be the answer. I also pointed out that since "you
haven't explained what else this expression will be required to produce.",
we cannot advise you of what it should be.

If you would care to explain your requirements we will endeavour to help.