Hi Sergy,

It gives me no records. If I take the between statement out of the SQL I get the correct records but obviously not between the 2 dates. I did try this manually by setting a filter against the cursor:

select result
set filter to Between(date,{^2003-04-01},{^2003-04-02}) 

This worked! But as soon as I use the syntax on my previous thread I am getting no records found.

Many Thanks