Please - new question - new thread.


WRONG is the missing AND (... AND !EOF)

but:

SCAN FOR BETWEEN(ldDate,from_date,to_date)
..
ENDSCAN

Will do anyway

Agnes
>Thanx for the help Terry another Q for if ur not to busy
>
>Is there somthing wrong with this expression as its giving me an error.
>
>
>
>SELECT ehrbt
>LOCATE
>SCAN FOR BETWEEN(ldDate,from_date,to_date) !EOF() &&lddate = user date input
>
>Thanx