Date data mismatch error with link to another table

[rubenfarias]

Im trying to use a field related to another table, the field is a date datatype which is in local format (DD/MM/YYYY) but the lookup tries to use another data forma (MM/DD/YYYY) so its not retrieving properly.

Fecha de Facturación and Fecha (from another table) are both in local format

But the datatype link from one table to the other search in another format so it fails...

anyone who has passed through this problem?

[TheTimeSavingCo · Accepted solution]

Try setting the 'Format' of the primary date field to be 'European'.  Once you do that when you open the linked record picker it should show with the day first, then the month
 

 

[rubenfarias]

Thanks very much, it worked!!