Buy Now
Sign in

Show number of records from today

Fredolino , January 21 2020, 00:31
Fredolino 629
January 21 2020, 00:31 #390818
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 9
January 21 2020, 02:47 #390819
 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}
Web developer at SkySpider.com.au - I DO NOT work for ChronoEngine!
Donations: paypal.me/healyhatman
Professional Work: kamron@skyspider.com.au
Custom CF / CC Plugins and Extensions: skyspider.com.au/store
Fredolino 629
January 21 2020, 10:26 #390824
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}