Neil,

Maybe there are no records for 'pdmlog.type="Change" and pdmlog.database="COST2"' for that period? To verify that try from command window

SELECT mainkey FROM pdmlog + ;
  WHERE pdmlog.type="Change" and pdmlog.database="COST2" ;
  ORDER BY date

and check if there're records from {^2003-04-01} TO {^2003-04-02})

>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