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.