0 Replies Latest reply: Jan 6, 2011 8:54 AM by Piyunisha RSS

    Validating input date parameter against chart object

    Piyunisha

      Hi,

      I need to run a qv chart object having CALENDAR_DATE column for the date range given by the user in variables StartDate and EndDate.

      I have written the following in a Run Macro trigger to perform the same but not getting the desired output.

       

       

       

       

       

      startDate = ActiveDocument.variables("vStartDate").GetContent.String & "*"
      endDate = ActiveDocument.variables("vEndDate").GetContent.String & "*"
      selexpr = ">=" & startDate & "<=" & endDate
      ActiveDocument.GetField("CALENDAR_DATE").Select(selexpr)

      I would appreciate any help.