🚀 go-pugleaf

In misccode.htm by Ken Mayer it is said under Filters/The Filter
Property:

PROBLEM:SQL itself does not understand non-US date formats. This
is not a BDE issue, nor is it a Visual dBASE issue ... This means
you need to use US/American date format of MM/DD/YYYY.

How literal should this be taken?

I have tried to incorporate two of Ken's examples (Dates: under
The Filter Property and Replace All: under SQL, right at the
beginning of the paper) in the attached program using European
date format (DMY) only and it seems to work. The program creates
a table, fills it with dates using 'insert into ...', generates a
form with a grid datalinked to the table and pusbuttons to update
and filter the dates. As far as I understand it all is done using
OODML, hopefully even SQL.

The only difference from Ken's examples is that I can not insert
the function 'date()' directly into the sql commands but need to
use either a parameter (dat = date()) or a variable (dato =
date()). It is even possible in some cases to insert a date in
curly brackets directly into the sql statement.

Any comments?


Ivar B. Jessen