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.

5 Responses so far.

  1. daspeac says:

    get the word recovery utility to fix data corruption issues in the files of specified format

Post a Comment

Thank you for your comment.

Any request and idea are welcome.

CLICK TO REGISTER