[SOLVED] Display only entries from last 30 days

Hi.

I have a custom CC listing. It currently shows all the entries. Is there a way to limit the results so that only the ones created in the last month are displayed?

I guess this should not be too complicated, but my knowledge of SQL is very very little.

Thanks!

Hi sarkomand,

You can use the WHERE box to filter the results.

Bob

Thanks.

Seems like I got it working with

cf_created BETWEEN CURDATE() - INTERVAL 30 DAY AND NOW()

Hi sarkoman,

Great; and good to know you can do that.

Bob

That's an awesome yet a pretty simple line of code that made my life easier.

However, a quick question. Will it work with specific dates, ie.
BETWEEN CURDATE() - (given date: 05-01-2013) AND NOW()
?

Hi marcinwolejko,

I think that this should work:

BETWEEN '2013-01-05' AND NOW()

Bob

Hi Bob

Thanks a lot for the code! Appreciated🙂