Filter Joomla articles by year

Hello,

I want to display Joomla articles from an external database. Thats fine whith CCv5.

On the front list, I would need a drop down filter with YEARS like "2017","2016" using the Joomla `publish_up` date.

1 - On selecting a YEAR, the corresponding articles would be displayed
2 - The YEARS values in the filter would be existing YEARS stored in the field Model.publish_up

Is it possible to achieve that, knowing that the date value stored in Model.publish_up looks like "2017-02-07 13:44:20"

Thanks in advance for your answer .

Hi cb75ter,

The condition should be set to something like this

strtotime("2017-01-01 00:00:00")

Best regards,
Max