7 Replies Latest reply: Jul 15, 2016 3:15 AM by Vikram Vangala RSS

    Date formats

    Lorna Louw

      hi all.


      1. I have a qvw that has a date field Sale_DateM in the format (12/1/2015) - MM/DD/CCYY.


      2. I want to create an Nprint filter to filter for the last 3 months' info (from first day of month, 3 months ago...i  e for today, it will be 01 May 2016.



      a) how do I get the last 3 months from the Sale_DateM field (as explained above)?

      b) In the Nprint nsq...I create a filter based on the variable. I dont quite understand how.(see enclosed snapshot) do I put in the whole expression in the Value part?


      thank you - much appreciated.