2 Replies Latest reply: Dec 26, 2017 11:35 AM by prabhu muthukrishnan RSS

    Filter/Field edit on NPrinting

    Rentia Claassens

      good day

       

      currently I have an published report that pulls data for the current month.

      the filter field being used is =only({=$(=Date((Today() )))}YearMonth)

       

      I'm relatively new to nprinting and sql, how can this formula be changed to get the Prev Months data.

      for example it runs now from 1Dec to 31 Dec

      but the require 1 Nov to 30Nov

       

      thanks