AnsweredAssumed Answered

Help converting Text Timestamp to Valid FileMaker Timestamp

Question asked by WilliamK on Jan 22, 2013
Latest reply on Jan 24, 2013 by WilliamK

Title

Help converting Text Timestamp to Valid FileMaker Timestamp

Post

Hi,

     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.

Williamk

      

      

Outcomes