Is the external file a filemaker file? If not, what does the timestamp look like?
If it's a FM timestamp then:
GetAsDate ( timstamp field )
Should work fine. Make sure calculation result dropdown says Date
It's coming from an ODBC external file. The screenshot shows the original field on top and the field I've used the calc on below. I've tried saving the new field as text and date. Both look fine on screen but on export, the delimiters are stripped out.
My bad. In trying all the different ways, on the last try I forgot to change the drop down back to date. It is fine now. Thanks for your help. It would have taken a while, otherwise, to notice that the drop-down was text.