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

    Year in dates between




      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.