AnsweredAssumed Answered

Easiest Way to Change Date Format

Question asked by Terri on May 23, 2013
Latest reply on May 24, 2013 by philmodjunk


Easiest Way to Change Date Format


     I've imported an excel file and a column that had a date in it was formatted as general. When it came into FileMaker it came into a date field and is formatting as 05/05/2013. Even when I change the format of the date field in FileMaker as no leading characters for date and month it still appeares with two-digit days and months. I need the date to appear as 5/5/2013.

     Is there an easy way to update all the records (over 200,000) or is it easier to re-import the data with the field in excel correctly formatted as a short date field? Looking for a quick and easy fix. Thanks!

     By the way, using FMPro 11 Advanced.