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

    Comparing date formulas

    AJ.Yusuf

      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?

       

      thanks

       

       

        • 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

           

          Ritesh