
Date format with ODBC 2.54 throught Visual Basic 6 and Access 97
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?