Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Try Sum({$<DateOrdPlaced={">$(=Date#($(vReportDate),'MM/DD/YY')-30)"}>} AmtTotLine)