Calculation To Modify Date After Import
I am setting up a database to grab all of the fields from a tab deliniated file generated by Amazon. Everything works good except for the Purchase Date field which is formatted with the date. The text in each date field is formatted like this:
Is there a calculation that I can use to allow Filemaker to interpret the format and spit out the date only?