2 Replies Latest reply: May 12, 2015 7:16 AM by Fabian Wannemüller RSS

    ActiveDocument.Fields  .Select

    frank volpe

      I need to select a rolling 12 months of data when I select a chart.  The field I need to select on is YrMonth which is in the format 12012-01.

       

      sub SetRolling12Mo

      ActiveDocument.Fields("YrMonth").Clear

      ActiveDocument.Fields("YrMonth").Select "<=" & Year(now()) & "-" & Month(now())

      end sub

       

      Any help woudl be appreciated.