>>>>>>Hi Tore
>>>>>>
>>>>>>Nice to see other than me online.
>>>>>>
>>>>>>Are you any good at SQL? cos I sent this message yesterday and I can't figure why my SQL was working fine but now just selects all, or many, operators
>>>>>>
>>>>>>Message #1141384
>>>>>>
>>>>>>I'd really appreciate any help, and I'm going round lately cap-in-hand, as I need to get this finished before tommorow of I don;'t go on holiday (all booked)
>>>>>>
>>>>>>Cheers
>>>>>>
>>>>>>Terry
>>>>>
>>>>>Is this "real" SQL or VFP SQL? If it's "real" SLQ, I have to pass, since I only have experience with VFP SQL.
>>>>
>>>>No VFP (7) SQL :-)
>>>
>>>Well, at least I see that the Between syntax in the Where clause is incorrect:

>>>And (ET.date BETWEEN ldStartCurr and ldEndCurr ;
>>>  OR ET.date BETWEEN ldStartPrev and ldEndPrev)

>>
>>No, this is legal VFP SQL Between, as opposed to the VFP BETWEEN() function. This is not the problem. The dates are never null AFAIK :-)
>>
>>>Should be something like

>>> And (between(ET.date,ldStartCurr,ldEndCurr) ;
>>>  OR between(ET.date,ldStartPrev,ldEndPrev))

>>>What happens if ET.date is empty or NULL?
>
>You learn something every day....! However, since I am still in "summer mode" and actually busy mowing my lawn right now, I am sorry that I can not give you any more help at the moment.

Thank you all the same, Tore. Hmmm, a laptop on your lawnmower handlebars - what will they think of next? :-)