"I can't figure out how to achieve the same result in FM Pro ,"
What result is that? Do you mean that you want to import the timestamp only as a date? Or do you mean that you want the result to display on your layouts as Oct 30 2009 9:34 AM?
Have you tried importing the timestamp into a date? It should work fine. If it does not work then you the actual data must be Oct 30 2009 9:34 AM as text which will mean a conversion once inside FileMaker. You would need to import into a text field and then a date field can convert it. Here is one way:
Create a text field called textDate. You will import your pseudo timestamp into textDate. Then create a calculation (result is date) with:
Ceiling ( Position ( "janfebmaraprmayjunjulaugsepoctnovdec" ; LeftWords ( text ; 1 ) ; 1 ; 1 ) / 3 ) ;
MiddleWords ( text ; 2 ; 1 ) ;
MiddleWords ( text ; 3 ; 1 )
After your import, check this date calculation. If it displays as you wish, go back and change it to a date field. The values from the calculation will remain as actual data and you can then delete the text field.
Thanks LaRetta! works perfectly and I appreciate your help very much. I'll get back to trying to flatten my FM learning curve and, hopefully, sometime in the future be able to help out a nooby too.