http://forum.lowyat.net/ Fri, 30 Oct 2026 06:23:19 +0800 FeedCreator 1.7.2 http://forum.lowyat.net/topic/4982659 If I have a table with column Name and Creation_Date that looks like<br /><br /><!--c1--><div class='codetop'>CODE</div><div class='codemain'><!--ec1-->Name, Creation<br />Sam, 01/01/2020<br />Sam, 01,02,2020<br />Jack, 12/31/2019<br />Jack, 10/21/2018<br />Jack, 12/30/2019<br />Hank, 01/01/2019<!--c2--></div><!--ec2--><br /><br />What I want is if Name matches and creation date for that name is within +/- 1 day, I would like to get those rows. In this case, I want 4 rows of data as output. I can only filter on certain range but not within Name level. I also tried with <a href='https://www.janbasktraining.com/blog/what-is-the-substring-function/' target='_blank'>substring function</a> but no luck. <br /><br />Your help will be appreciable vikasbook Linux &amp; Open Source Software Fri, 19 Jun 2020 21:41:16 +0800