Olaf tells me that it's stored as Text-String. Either as 'yyyy-mm-dd' or 'yyyy-mm-dd hh:mm:ss', depending on how I decide to store my VB type dates.
Anyway, the original problem was solved. I simply neglected to address the need for 'quotes' around my date variable. Thanks Rich. :-) Rick #>-----Original Message----- #>From: sqlite-users-boun...@sqlite.org #>[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Rich Shepard #>Sent: Monday, August 03, 2009 5:18 PM #>To: General Discussion of SQLite Database #>Subject: Re: [sqlite] Date Comparisons SQL #> #>On Mon, 3 Aug 2009, Rick Ratchford wrote: #> #>> It was set as String actually. #> #>Rick, #> #> That's the storage class; well, TEXT is the storage class. #> #>> I believe this is a WRAPPER thing though. I'm programming #>in VB6 and #>> using Olaf's VB wrapper. #> #> Oh. I know nothing about Microsoft languages (or operating #>systems for that matter), except that they're different. I do #>all my coding in C or Python. #> #>Rich #> #>-- #>Richard B. Shepard, Ph.D. | Integrity #> Credibility #>Applied Ecosystem Services, Inc. | Innovation #><http://www.appl-ecosys.com> Voice: 503-667-4517 #>Fax: 503-667-8863 #>_______________________________________________ #>sqlite-users mailing list #>sqlite-users@sqlite.org #>http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users #> #> _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users