1 2 Previous Next 15 Replies Latest reply on Mar 16, 2016 6:09 AM by disabled_morkus

    Replace Date fields with correct format DD/MM/YYYY

      Currently - I have a few users in my database that are entering dates in the following format DD.MM.YYYY - FileMaker understands that this is a date however, I would like to create a script and also a Replace Field Contents with it in the following format DD/MM/YYYY - with the slashes.

       

      The reason is I have problems importing this to SQL when the format is in dots(.), hypens(-).

       

      Ideally, if I could convert all dates to DD/MM/YYYY that would be great.

        1 2 Previous Next