Forums

Please write a review for the extension you are using on the Joomla extensions directory before posting a new question as we are being spammed by many negative reviews.

Thank you for your support!

Show number of records from today

Fredolino 21 Jan, 2020

Hi,

The setting
select type: Return the count of records matching the filtering conditions.
Where conditions: blank
{var:read_count_arten_day}: The number "12" is displayed. That's right.

But I just want to show today's number of records.
Today's date is in the "created" column.
How does it work?
Where condition: Arten.created = {date:}
only shows me "0".

F.

healyhatman 21 Jan, 2020

Answer

Is your date column a "date" type or a "datetime" type? If it's just "date" then you want = {date:Y-m-d} otherwise you will have to convert the date, or possible try >= {date:Y-m-d}

Fredolino 21 Jan, 2020

the "created" column is type datetime. But with {date:Y-m-d} works. :-)

select type: Return the count of records matching the filtering conditions.
Where conditions:
Arten.created >= {date:Y-m-d}

This topic is locked and no more replies can be posted.