Avatar of IrishStudent

asked on 

PHP Mysql Find all clients whose last visit is six months or greater

Hi all,

I have a table that records appointments for clients which among other fields has a single DATE field  called gapmtDate that records the date of the appointment.

Can anyone tell me how I can find all clients whose last visit was  greater than six months ago from todays date.

Many thanks in advance.

Avatar of undefined
Last Comment

8/22/2022 - Mon