Converting imported date field from 20150625 to 2015/06/25
when i import records from source they have no - or / in them and filemaker will not recognize them as a date.
i have tried placing a button on layout that works with found set and uses a script
Insert Cal Result ------- Left (date;4) & "/" & Middle ( date ; 5 ; 2 ) & "/" & Right ( date ; 2 )
GoToRecord (Next Exit after Last)
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.