Filtering by date of acceptance of Terms and conditions

Good afternoon, tell me the solution to the problem. I have users get a new level of access after downloading data and checking the terms and conditions.

It takes a very long time to unload the components, too much extra data has to be pumped out. It would be easier to unload only those who ticked in October, rather than all those with access. But there is no filtering by accept date. I even tried to make a list, but there is also no filtering by date, only the presence of a mark.

Tried third-party extensions, they also do not take into account the accept date.

I assume you're wanting to filter a userlist and not CB > User Management? For a userlist you'd use an Advanced filter. This allows you to directly add to the WHERE statement of the userlist query. Terms and Condition fields store their acceptance date in a FIELD_NAMEconsent column. This means for the core terms and conditions field the date is stored in acceptedtermsconsent column. You can filter against that in your userlist. Example as follows.


That should display everyone who accepted the terms in the last month from today. the "ue" table alias is for _comprofiler while "u" table alias is for _users. See the below MYSQL documentation for further date usage information in SQL.

dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html