- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
āJan 06, 2025 12:45 AM
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?
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
āJan 06, 2025 01:53 AM - edited āJan 06, 2025 01:53 AM
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ā
ā
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
āJan 06, 2025 01:53 AM - edited āJan 06, 2025 01:53 AM
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ā
ā
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
āJan 06, 2025 11:12 AM
Thanks very much, it worked!!
