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

Discussion created by megabunster on Sep 27, 2015
Latest reply on Sep 27, 2015 by 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!