+3Im 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?
Best answer by TheTimeSavingCo
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
+31Try 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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.