AnsweredAssumed Answered

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

Question asked by DennisFlight on Jun 22, 2015
Latest reply on Jun 22, 2015 by philmodjunk

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.

Outcomes