BROWSE between two dates??

[baileybelle]

How would you use the BROWSE command to search a table between two dates and meeting another criteria? For example using an SQL statement I might use something light this..

SELECT * FROM tablename WHERE date between date1 and date2 AND companyname = 'ABC'

How could this be accomplished with the BROWSE or COUNT commands?

 

[CJWARNER]

After having the appropriate table selected:

BROWSE LAST FOR BETWEEN(dateval,date1,date2) AND companyname = 'ABC'

 

[ramani]

Hi

BROWSE FOR BETWEEN(myDate,date1,date2) AND ;
companyname == 'ABC'


ramani
(Subramanian.G),FoxAcc, ramani_g@yahoo.com