1 Reply Latest reply on Dec 30, 2013 6:10 AM by philmodjunk

    Find records based on timestamp



      Find records based on timestamp


           I wan to find records which are created between e.g 12/30/2013 11:30:00 A.M to 12/30/2013 5:30:00 PM
           I try foloowing script bit its not working
           Enter Find Mode
           Set Field[created_date:12/30/2013 {11.30:00 AM..5.30:00 PM}
           Perform Find[]

        • 1. Re: Find records based on timestamp

               perhaps it's a typo in your post, but set field should have this format:

               Set Field [ TableOccurrence::Field ; Expression ]

               Which is not what I see in your post.

               Try using

               Set Field [ YourTable::created_date ;12/30/2013 11.30:00 AM..12/30/2013 5.30:00 PM ]

               When Setting up Set Field, there are two Specify buttons that must be clicked. To get Set Field [Table::Field ; Expression], add set field to your script and click the first button (specify target field). Select Table::Field from the list of fields. Do not click the specify button next to the repetition box. Click OK to close this dialog box. Now click the lower specify button (calculated result) and create the expression to the right of the semicolon (;). Do not try to type in the semicolon.