Help! Need to convert imported timestamp

[bellwether]

Hello. I have no experience with FileMaker scripting. I have been asked to convert the "01-May-2008 12:21:55 PM PDT" to a "Month,Day,Year" format. Can anyone point me in the right direction? Or from the kindness of your heart, can someone whip up a script for me??

Thanks a head of time,

Joe Young

[comment]

You need a calculation, not a script. Try:

Date( 

Int( Position( "janfebmaraprmayjunjulaugsepoctnovdec", Left( MiddleWords( Imported, 2, 1 ), 3 ), 1, 1 ) / 3 ) + 1, 

LeftWords( Imported, 1 ), 

MiddleWords( Imported, 3, 1 )

)

Make the result a Date - this will convert the imported text into a valid Filemaker date, which can then be formatted any way you like.