8 Replies Latest reply: Aug 27, 2015 2:43 PM by Darrin Pilkington RSS

    Single date variable between two dates in set analysis question

    Darrin Pilkington

      All the samples of date range in set analysis I find show a similar format of a single date record between two date variables selected like here.

      Sum({< CalendarDate = {'>=$(=Date(vStartDate))<=$(=Date(vEndDate))'} >} SalesAmount)


      I have Start and End record dates and need to have a single date variable range.



      Sum({< vDateVariable = {' >= (RecordStart)  < (RecordEnd) '} SalesAmount)


      All the ways I have tried with the RecordStart and RecordEnd dates not recognize the columns once in the set.


      Thanks for your help.