I have a problem with date format.
The file is a Btrieve version 7. (Pervasive.SQL with SP3 running on a NT
Server, )
doing the next command:

select * from ValePrev where FechaEmision=#" & FechaIni & "#"

depending of FechaIni's value, works or not.

if fechaini='01/03/1999' (first of March) doesn't work.
but with fechaini='31/03/1999' works fine.

My regional setting is Spain (date format dd/mm/yyyy)

I've tried to modify the Pervasive odbc options with no result.

The fact is that the value i get is correct displayed by visual basic and
access filters correctly both sentences.

Any idea?