Subject Re: D2109 - INSERT INTO for a literal date doesn't seem to recognise From Mervyn Bick <invalid@invalid.invalid> Date Mon, 3 Mar 2025 08:26:50 +0200 Newsgroups dbase.getting-started On 2025/03/03 07:16, BRUCE HEATH wrote: > Thanks Ken, > > Appreciate the rapid feedback. > > Tried  MM/DD/YYYY and that worked fine, so YY or YYYY doesn't seem to make a difference. > > Tried YYYY/MM/DD and it threw the same "Database Engine Error : Type mismatch in expression". > > Guess I'm stuck with doing it in US format. > > Cheers. > The default format for a literal date in "proper" SQL is yyyy/md/dd. localSQL, as implemented in the BDE for use with .dbf files, will, however, only accept literal dates as American i.e mm/dd/yyyy or German i.e dd.mm.yyyy See "Date format" in the localSQL help file for more detail. C:\Program Files (x86)\Common Files\Borland\BDE\localsql.chm Mervyn.