4 Replies Latest reply on Dec 19, 2016 5:24 AM by Norbert Maijoor

    Year in dates between

    Yakis Yak

      Hi,

       

      I have problem with calculation for date filter. I have date parameter year for example set to '2016' and need find all records where year 2016 existing between start and end.

      For exmaple:

         

      2015-08-312016-12-312016 exist
      2016-06-282019-06-302016 exist
      2016-11-012017-11-232016 exist
      2012-05-212018-12-312016 exist

       

      Example sheet in attachment.

       

      Thx for help.