AnsweredAssumed Answered

Calculation To Modify Date After Import

Question asked by StephanKrasner_1 on Nov 13, 2013
Latest reply on Nov 13, 2013 by philmodjunk

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?

      

Outcomes