Query with where clause of a Date Criteria or Conditio from DBF Foxpro with Excel VBA

[antoni]

How to Query (SQL Statement) a Date Criteria or Condition on where clause in a Trx table (Dbf Foxpro) with Excel VBA, please..

my trx table have a datetrx field with format mm/dd/yy, but on my PC the date format is dd/mm/yy.

Thanks

Best Regards