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



Tue, 25 Sep 2001 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Access 97 and Visual Basic 6.0

2. Calling Visual Basic Modules from Access 97

3. Visual Basic Database and Access 97 System.mdw

4. Access 97 sercurity problem in Visual Basic.

5. Corruption, Access 97 & Visual Basic 32-Bit

6. Date format from VB5 form to Access 97

7. Access 97 / Visual Basic

8. Need help: Using Visual Basic 6.0 to create Modules in Access 97

9. Need help: Using Visual Basic 6.0 to create Modules in Access 97

10. Motor de Access 97 con Visual Basic 3.0(Muy Urgente)

11. calling an access 97 report from visual basic


 
Powered by phpBB® Forum Software