6 Replies Latest reply on Jun 10, 2015 11:22 AM by FileKraft

    Use System Formats not File Format gets mixed up function results of date fields

    FileKraft

      Summary

      Use System Formats not File Format gets mixed up function results of date fields

      Product

      FileMaker Pro

      Version

      13v5

      Operating system version

      Mac and Win same bug

      Description of the issue

      getNthRecord ( Table::DateField ; AnyValidRecNum ) returns the date in File Setting

      Date Viewer shows same field referred directly as Table::DateField in System Settings as expected

      Steps to reproduce the problem

      create a clone of a file originated with US English System Settings
      open the file by a British OS using System Settings
      now file has stored International System Setting
      Date s are displayed DDMMYYYY
      switch the file to use system settings and open on US Englisch OS

      getNthRecord ( Table::DateField ; AnyValidRecNum ) returns the date in File Setting

      Date Viewer shows same field referred directly as Table::DateField in System Settings as expected

      Expected result

      Date Format should be consistent everywhere by any date field displayed

      Actual result

      mixed date formatting

      Exact text of any error message(s) that appear

      no error - but data gets compromised because sometimes days and month numbers switch

      Configuration information

      on all computers tested - windows PC - macs ..

      Workaround

      rewriting date fields with tagged coding -  very tedious