2 Replies Latest reply on Jun 22, 2015 10:41 AM by philmodjunk

    Converting imported date field from 20150625 to 2015/06/25

    DennisFlight

      Title

      Converting imported date field from 20150625 to 2015/06/25

      Post

      when i import records from source they have no - or / in them and filemaker will not recognize them as a date.

       

      Ex. 20150625

      i have tried placing a button on layout that works with found set and uses a script

       

      GoToRecord (First)

      Loop

      Insert Cal Result -------    Left (date;4)  & "/"  & Middle ( date ; 5 ; 2 )  & "/"  & Right ( date ; 2 )

      GoToRecord (Next Exit after Last)

      End Loop

      This works fine as long as i only hit the button once (run script once) if i accidentally runs the script a second time all the dates ends up with more /// in them.

      Thanks.