With Access, dates have to be surrounded by # and the date format has to be compatible with not only the language you are using but SQL as well.
I recommend checking the SQLite docs on acceptable date formats as I have done this with success ------Original Message------ From: Fabio Stranieri Sender: To: sqlite-users@sqlite.org ReplyTo: General Discussion of SQLite Database Sent: Oct 8, 2008 14:14 Subject: [sqlite] from access to sqlite I'm trying to replace db access from my vb6 program to sqlite. But this query no work "SELECT * FROM " & nome_tab & " WHERE data_ora BETWEEN " & Format(ieri_inizio, "yyyy/mm/dd hh:nn:ss") & " and " & Format(ieri_fine, "yyyy/mm/dd hh:nn:ss") & " ORDER BY data_ora" where ieri = Date - 1 ieri_inizio = ieri & " 00:00:00" ieri_fine = ieri & " 23:59:59" can we help me? -- Fabio _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users Timothy A. Sawyer, CISSP Managing Director MBD Solutions Phone: (603) 546-7132 Web: http://www.mybowlingdiary.com Email: [EMAIL PROTECTED] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
