Help converting Text Timestamp to Valid FileMaker Timestamp
I have data that is imported into a Date field from a CSV file. The filed is called "Date". All the dates are in this format
Jan-07-13 22:48:43 PDT
The import succeeds, but FileMaker does not sort the data properly or allow my to search by it. If I do a search in the date field for invalid date (ie ?) it returns all the records. So obviously it does not like this date format. I tried changing the Date field to field type text and creating a second calculated field returning a timestamp, and using the GetAsTimestamp(date) function as the calc, but it returns question marks.
How can I convert this type date format into something FM will recognize as a valid timestamp? Thanks.