8 Replies Latest reply on Jan 24, 2013 3:27 PM by WilliamK

    Help converting Text Timestamp to Valid FileMaker Timestamp

    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