2 Replies Latest reply on Dec 6, 2013 4:51 AM by SamThomas

    How to find records based on timestamp

    SamThomas

      Title

      How to find records based on timestamp

      Post

           I m trying to import csv file in which there is a field "created date" which is in yyyy-mm-dd hh:mm:ss format . I m trying to find records based on timestamps e.g want to find records which are created between 2013-12-06 {14..17}:00 .Its shows error "This value of this field must be a valid timestamp .......

      should like this "12/25/2003 11:09:03 PM""

        • 1. Re: How to find records based on timestamp
          philmcgeehan

               This will convert your yyyy-mm-dd hh:mm:ss to mm/dd/yyyy hh:mm:ss

          EDIT: providing your existing field always has the same amount of characters. e.g. the date is always 2013-12-06 and not 2013-12-6

               = Middle ( CreatedDate ; 6 ; 2 ) & "/" & Middle ( CreatedDate ; 9 ; 2 ) & "/" & Left ( CreatedDate ; 4 )
               & " " &
               Middle ( CreatedDate ; 12 ; 2 ) & ":" & Middle ( CreatedDate ; 12 ; 2 ) & ":" & Right ( CreatedDate ; 2 )

               Perhaps make a new field with a FM standard timestamp.

          • 2. Re: How to find records based on timestamp
            SamThomas

                 Hey Thanks for reply..but I create new field type timestamp in calculation field I add this script ..but its not working if I  write this in set field then its working