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.