Guest_imported
New member
- Jan 1, 1970
- 0
- 0
- 0
i have a problem with a sql sentence
"SELECT * FROM saldoa WHERE mo = 1 AND (fecha BETWEEN #" & DTPicker1.Value & "# AND #" & DTPicker2.Value & "#)"
"saldoa" is the name of the access database
"mo" is a field
"fecha" is the date field
then i want all the records whose in the field "mo" = 1 and between 2 given dates
the problem is that the sentence can´t find the records, could be the format of the date?
i have visual basic 6 sp5 in spanish and the date in this version is dd/mm/yyyy and i guess sql handle the date mm/dd/yyyy plus i have the long date format in the database,that include the hour.
thank you for your help
"SELECT * FROM saldoa WHERE mo = 1 AND (fecha BETWEEN #" & DTPicker1.Value & "# AND #" & DTPicker2.Value & "#)"
"saldoa" is the name of the access database
"mo" is a field
"fecha" is the date field
then i want all the records whose in the field "mo" = 1 and between 2 given dates
the problem is that the sentence can´t find the records, could be the format of the date?
i have visual basic 6 sp5 in spanish and the date in this version is dd/mm/yyyy and i guess sql handle the date mm/dd/yyyy plus i have the long date format in the database,that include the hour.
thank you for your help