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.

       

      Example:

      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.