[SOLVED] Filtering List by Date

Apologies - this is a really stupid question, and I will probably feel even more stupid, once the answer comes... However, neither in the documentation nor in the forum I found the answer to this simple question.

To provide a list of "expired" members I would like to filter by date in the following format

cb_expiration_date smaller than today's date

For today's date I tried:

• date
• date()
• 'date'
• 'date()'
• var.date

and a few more... Can't think of any others...

Thanks for your help.

You have to use an advanced filter for that. Basic filters won't work in this case. Example advanced filter as follows.

ue.`cb_expiration_date` (less than or equal to operator.. excluded due to kunena bug removing it) NOW()

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

The "ue" table alias is for _comprofiler table and "u" alias is for _users table.

Okay, I don't feel quite as stupid after all ...

1. It wasn't that obvious
2. I was able to implement the solution with your instructions

Thanks.