>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

Bilal

You seem to be mixing up a DO WHILE and a SCAN construct. It's the !EOF() that's throwing the code. I'm not sure you can put them on the same line either (I certainly never have, and it makes the code less readable). Scan already implies until EOF, and your scope clause takes care of what rec's are uincluded in the scan.
See below:

SCAN FOR BETWEEN( ldDate, from_date, to_date)
EndSCAN