1 Reply Latest reply on Sep 3, 2018 3:32 AM by Ritesh Bisht

    Comparing date formulas


      Hi All


      Hope you are well?


      Sorry for this basic question


      I have two data sets with two dates and individual customer ids


      data set 1: date1

      data set 2: date2


      Basically i need a formula where



      I need the the first date (Basically the min)  from (data set 2) date2 which is greater then max(date1) which is from data set 1


      it has to be greater the data set 1 but basically the first date which is


      How can I achieve this?





        • 1. Re: Comparing date formulas
          Ritesh Bisht

          Hi Yusuf,


          I believe you are blending 2 data-sources


          Here I am using 2 different data-sources of sample superstore


          1) Having years 2018,17,16,15


          2) Having years 2017,16,15,14


          Screen Shot 2018-09-03 at 3.53.48 PM.png



          So, basically I need the date 31/12/2017 min of one > max of 2



          Screen Shot 2018-09-03 at 3.56.22 PM.png



          So ,basically Order Date of 1 should be greater then Window_Max of 2 which is the basic funda here



          Screen Shot 2018-09-03 at 3.58.18 PM.png



          Screen Shot 2018-09-03 at 3.57.46 PM.png


          Last we need to filter the first element with the help of DATEDIFF


          Screen Shot 2018-09-03 at 3.59.53 PM.png


          Please find the attachment and mark it as CORRECT & HELPFUL if it really helps you so that it can help others