1 Reply Latest reply: Nov 9, 2018 1:37 PM by Gysbert Wassenaar RSS

    Date Variable in Set Analysis

    David Robinson

      I have a date field called DateOrdPlaced. I have a variable called vReportDate. It looks like this:  10/31/18. I want to report on all records that have a DateOrdPlaced within the last 30 days of the vReportDate. That is vReportDate -30. Starting with this formula, how can I obtain that?

       

      Does someone have an article or white paper on using date variables in set analysis?

       

      Sum({$<DateOrdPlaced={">$(vReportDate)-30"}>} AmtTotLine)