4 Replies Latest reply: Jan 20, 2017 5:50 AM by Anat Dagan RSS

    Set analysis for date range made of 2 date variables

    Anat Dagan

      Hi,

      I have 2 variables set up as start and stop date named:

      vStartDate

      vEndDate

       

      I want to set up a date range limitation via set analysis to be used on a chart so that the chart will only display data for the range between these 2 dates.

       

      I managed to set up the vEndDate limit but i can't figure out how to add the second condition (vStartDate). Can you please help me with the syntax?

       

      This is my set analysis with the EndDate condition which is working:

       

      Sum({$<Date={"<$(vEndDate)"}>}Sales)