Not updated in 3 months

This topic is locked

Not updated in 3 months	10/18/2023 5:40:07 AM
PHPRunner General questions
S stevealexa author Hi All. I have a blonde moment. My project contains 6000 records of visits to properties, and I want to query any property that has not been visited in 3 last months Table one Sites - field 'Propertiesid' table two ( child of table one) 'visits' - update field (date) Outcome = which of the properties have not had a visit in last 3 months. phprunner 10.91 / mysql db I have a complete blank on this, would anyone be able to help me please?


	admin 10/18/2023
	What you looking for are properties where the difference in days between last visit and today's date is greater than 90. I recommend checking this article that provides many examples of date calculations: https://xlinesoft.com/blog/2014/11/12/datetime-handling-in-web-applications/