2 Replies Latest reply on Nov 14, 2011 1:14 PM by MacMak

    Find date range script

    MacMak

      Title

      Find date range script

      Post

      Hello.

          I need a simple script that will display all the entries done the last week from current date. Tried many different optiones from forum but none work. Basically I have a time stamp from creaton date and I need do display all the entries done in the past week from current date.

      Thanks and looking forward ot hearing from options.

        • 1. Re: Find date range script
          philmodjunk

          Tried many different optiones from forum but none work

          And what options were those? Since you haven't described those options, what I post may be something you have tried already.

          Assumptions I am making:

          "All entries" means all records.

          "last week from current date" means all records from todays date to 7 days ago.

          Enter Find mode [] //clear the pause check box
          Set field [Yourtable::yourTimeTampField ; ">" & Get ( CurrentDate ) - 7]
          Set Error Capture [on]
          Perform FInd []

          • 2. Re: Find date range script
            MacMak

            Perfect Thanks!