Skip to main content

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?

 

 

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
 

 

 

Thanks very much, it worked!!

Reply


Terms & Conditions