3 Replies Latest reply on Nov 13, 2013 8:33 PM by philmodjunk

    Calculation To Modify Date After Import

    StephanKrasner_1

      Title

      Calculation To Modify Date After Import

      Post

           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:

                                                                            
                          2013-11-11T20:53:28+00:00

           Is there a calculation that I can use to allow Filemaker to interpret the format and spit out the date only?