Forums

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.