Accpac View Browse with date filter

[sara403]

Hi,

I am trying to fetch records in AR invoice for a particular date range using views.
Here i am using the following line
.Browse "datermit >=" & txtInvDateRangeFrom & " and datermit <= " & txtInvDateRangeTo, True

but it is not working.
But if i use only browse "",true then it gives me all the records but i need to put some filter for date in the browse.

Also i tried the following line (hardcoded date manually) but it fails
.Browse "datermit=#01/01/2008# and datermit<=#01/01/2008#", True

Please advise me whats wrong in the above code.

Thanks and Regards,
Sara

 

[ettienne]

.Browse "datermit=20080101 and datermit<=20080101", True