Re: Search Clause: where DATE >= 'YYYY-MM-DD' FAILS

[Duncan Groenewald <duncangroenewald@xxxxxxxxxx>]

Thanks...

Stefaan A Eeckels wrote:
> Hi Duncan,
>
> On Mon, 06 Nov 2006 23:49:28 +1300
> Duncan Groenewald <duncangroenewald@xtra.co.nz> wrote:
>
>   
>> Any suggestions as to why the following search clause fails to return 
>> any rows ?
>>     
>
> The syntax is as follows:
>
>  select P.Description, D.StartDate, D.DueDate,D.PromToRelActual
>  from ProjectWBS P, ProjectWBSDetail D
>  where ProjectCode = '011'
>  and D.ID=P.ID
>  and D.PromToRelActual >= DATE '2006-11-01'
>  and D.PromToRelActual < DATE '2006-12-01'
>  order by D.PromToRelActual
>
> Take care,
>
>