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.