"Fabio Stranieri" <[EMAIL PROTECTED]> schrieb im Newsbeitrag news:[EMAIL PROTECTED]
> "'11/10/2008 00:00:00'" As I see it, there's no need, to hardcode your Dates this way. You can use an appropriate Format-String to retrieve that directly from VB-DateVariables: Format(now,"'dd\/mm\/yyyy hh:mm:ss'") > That said, i have solved my problem, but i'm like to > understand why it no work with datetime format. It has solved your problem, because you imported the dates as text - and as I see it, the Date-String-Format you currently use is not really sortable or "comparable" as other Date-String-Formats, which normally need to begin with the year, followed by the month and day. Your current order is days, months, year inside your imported date-strings and that will cause problems with sorting, has "internationalization-issues" etc. So I'd strongly recommend, that you either change your self-defined Text-Date-imports to a "standard SQL-String-date" (starting with the year) or that you try to make it work with your original wrapper-providers datetime-format. Please ask their tec-support or read their docu on date- columns/date-imports from MS-DBs. And regarding your problems with STRFTIME - this is not a VB-Function - you would have to place it as Text in your Query-String. Olaf _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
