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.