5 Replies Latest reply: Mar 30, 2017 1:45 PM by Sunny Talwar RSS

    How to Write a Date Range in Using Set Analysis

    Praveen Kumar Konda

      Hello All,

       

      I have a If Statement like this:

      Count(If(Type = 'XXX' and Create_Date>=Date(Today()-14) and Create_Date < Date(Today()-7),ID) )

       

      and i would like to re-write the same using Set Analysis..How can we write it..i tried writing this way but somehow no luck.

       

      In Data Load Editor:

      LET Vtoday14=Today()-14;

      LET Vtoday7=Today()-7;


      In the Expression:

      Count({< Type = {'XXX'},Create_Date={">=$(Vtoday14)"} ,Create_Date={"<$(Vtoday7)"}) >} ID)

       

      Any help will be appreciated.

       

      Regards,

      PK