RE: [DUG-DB]: Dates in SQL/Access

[Derricutt, Mark]

> It should be mm/dd/yyyy if you're doing any sql in Access.

Thats what I thought, however the query:

  SELECT *
  FROM MeasuredData
  WHERE DateTimeAdded > '07/03/1999'

generates a "Datatype Mismatch in Criteria Expression" error.
---------------------------------------------------------------------------
  New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
                  Website: http://www.delphi.org.nz