How to query dates using Day-Month-Year using local SQL

Article #10357: How to query dates using Day-Month-Year using local SQL

Question:
How do I query a Paradox or dBASE table using Day-Month-Year instead of Month-Day-Year?
Answer:
The local SQL engine uses the separator to decide the format of a date. A / is interpreted as M/D/Y. A . is interpreted as D.M.Y.
Examples:
11/1/99 is November 1, 1999.
11.1.99 is January 11, 1999.

Last Modified: 19-OCT-99