Specifying a date in dbase

One of the recurring confusions with databases is how to specify a date value in SQL statements. In the case of dbase, it’s not just SQL but also the builtin language.

There you specify a date as


where <date> is the date in the format currently used for output.

e.g. if you are using the standard German date format:

replace all DATEFIELD to ctod("31.01.2014")