Fixing dates to ISO format during import
I've been trying to figure out how to set a date to a specific format yyyy-mm-dd. After setting up a custom date field format everything looks ok, but when I select the date field or export the data, the originally entered format shows up like mm/dd/yyyy. I need to permanently fix the date format to yyyy-mm-dd . When I gather data from other people they may enter the dates in a variety of different formats and still have a valid date, but when I import the data into my database I need it to convert the dates to be specific to what I need. The reason for it to be in this format is because I'm collecting data from multiple sources, cleaning up mistakes and then exporting and submitting my data file to another agency. The Date field is specific to their import. I know I can do this in another program before I import it into my database, but If It could all be done within FilemakerPro 12, it would be a huge time saver for me.