2 Replies Latest reply on Sep 15, 2011 8:31 AM by philmodjunk

    trying to create a report with a dater range

    SeanSarjoo

      Title

      trying to create a report with a dater range

      Post

       I ran the following calculation.. but its giving me errors

       

      LIDI::Exam Date;(LIDI::Start Date & "..." & LIDI::End Date)

        • 1. Re: trying to create a report with a dater range
          Sorbsbuster

          What is the rest of the script?  What are the errors?  Is this a script, or did you enter this manually in a Find?

          if you entered it manually you should have entered just the date range, eg: 1/1/2010...31/12/2010

          If it is part of a script it could have looked like:

          Go To Layout (make sure it is on a layout from the LIDI Table)

          Enter Find Mode

          Set Field [ LIDI::Exam Date;(LIDI::Start Date & "..." & LIDI::End Date) ]

          Perform Find (Untick the 'Restore Find Request')

          • 2. Re: trying to create a report with a dater range
            philmodjunk

            Perhaps it's the set field step that's the problem. Many new users have trouble with it the first time around:

            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.