2 Replies Latest reply on Feb 7, 2019 9:53 AM by shanmuga prabhu

    Date Range

    shanmuga prabhu

      Hi All

       

      I have two date fields from date and To date . It has to filter the date between from date and to Date

       

      Example

       

      Data set is from Jan 2018 to Dec 2018

       

      if I select Jul 2018 in from date , then the TO date field should show Jul 2018 to Dec 2018

       

       

      Attached demo file , if you could apply the logic and attach it back that will solve my query

       

       

       

      Thanks

        • 1. Re: Date Range
          Mavis Liu

          Hi Shanmuga,

           

          Your data structure doesn't work because both your month to and month from dates are running from the same field.

           

          So if you filter the 'to' date to January 2018, then the from date will always just be January 2018.

           

          What is your ultimate goal/what are you trying to achieve?

           

          Thanks,

           

          Mavis

          • 2. Re: Date Range
            shanmuga prabhu

            Hi

             

            Thanks for the reply

             

            Yes I need two date fields , I have to get all dates between start date and end date

             

            example

             

            start date : jul 2018

            end date : dec 2018

             

            01 jul 2018

            02 jul 2018

            03 jul 2018

            ..

             

            ..

            ..

             

            31 dec 2018

             

             

            looking for date range start date to end date