Date format issue in FM

Discussion created by sudha on May 10, 2016
Latest reply on May 10, 2016 by sudha

Hi all,


The date is stored in the format 10.3.2014 where in I am planning to update the date format to 10/3/2016.


As there are many number of records which has date with dot format, I have extracted the records in excel to find it out.

However, after exporting the format appears to be fine (10/3/2016) where in the filemaker the date is still present in dot format for the same record.


Could you please advise me why the date is showing in slash format in excel where as it is present in dot format in filemaker.


Thank you