3 Replies Latest reply on Sep 27, 2015 9:24 PM by megabunster

    How to convert various non-standard date formats to standard date in FileMaker Pro 14

    megabunster

      hello FileMakers,

      I am new to FileMaker and having a hard time figuring out how to have a calculation that would take various date formats in a date field and formatting them into a specific standard format!

      ie. If I enter 92715 it should give me 09/27/2015

      or if I enter 09272015 it should still give me 09/27/2015

       

      I need help I don't know where to go in the program to accomplish this task! So please I need someone to walk me through it step by step! I am still learning to navigate around in the program!