Get today's posts

Get today's posts

demyr
Senior Member
Posts: 322
Threads: 17
Joined: Sep 2018
Reputation: 7

09-17-2019, 01:25 PM

Doesn't TimeStampDiff approach help?

PHP Code:
->where('TIMESTAMPDIFF(DAY, start_date, now()) <= 180') 

This example shows items which were published in the last 180 days = 6 months here.

I use this for membership expirations. If member's period is more than 6 months, that member cannot see videos or any content etc.

Messages In This Thread

Get today's posts - by tp45 - 09-17-2019, 08:35 AM

RE: Get today's posts - by jreklund - 09-17-2019, 11:53 AM

RE: Get today's posts - by tp45 - 09-17-2019, 01:05 PM

RE: Get today's posts - by demyr - 09-17-2019, 01:25 PM

RE: Get today's posts - by tp45 - 09-17-2019, 02:12 PM

RE: Get today's posts - by demyr - 09-17-2019, 02:16 PM

RE: Get today's posts - by tp45 - 09-17-2019, 04:33 PM

RE: Get today's posts - by jreklund - 09-18-2019, 10:19 AM

RE: Get today's posts - by tp45 - 09-18-2019, 10:40 AM

RE: Get today's posts - by jreklund - 09-18-2019, 11:34 AM

RE: Get today's posts - by tp45 - 09-18-2019, 02:58 PM

RE: Get today's posts - by jreklund - 09-19-2019, 10:26 AM