I'm not sure what a date (or time) entry into a .dbf file is supposed to look
like either. I did a quick Google search for some info and found where
someone had asked the question elsewhere - perhaps reading through this
discussion will reveal the answer
http://www.ibm.com/developerworks/fo...d=161629&cat=5


"Erasmus" wrote:

I've been playing about some more - it looks like the SQL string is
too long - if I do it in chunks it works. Also, some of my syntax
wasn't quite right - I've changed it to allow for no single quotes
around numeric and boolean fields.

Now I have a date field (and a time field coming up) and I have no
idea what syntax to use there (am looking around but have no help
installed on work pc). I have tried # and both with and without single
quotes.