Get all pages of template created this month?

[onjegolders]

Hi guys,

Any ideas on how to get all pages of a certain template that have been created this month?

I have tried to test for "created" within the selector and combining it with date("m") but I'm not sure how to go about this?

My goal is to set invoice numbers combing an autoincrementing value with each invoice that is created within a given month.

Any ideas? 

Thanks

[arjen]

Will this work?

$pages->find("template=certain, created>=$firstdayofthismonth, created<=$lastdayofthismonth, sort-=created");

[DaveP]

I think 

$pages->find("template=invoice,created>".strtotime("1 ".date("M")))

should find invoices created this month. You'd need some extra logic for past months, but strtotime is the key.

[onjegolders]

Thanks both of you!

I went with yours Dave as I am extremely lazy

It works a treat!

[dotnetic]

2018 update:

You can also use strtotime in selectors since a while (don't know in wich PW version, but it works in versions > 3. So you could do:

$pages->find('template=invoice,created>"first day of this month",created<"last day of this month"'))

 

[wbmnfktr]

1 hour ago, jmartsch said:

You can also use strtotime in selectors since a while

Woah! 

I knew that today will work but... woah!

That makes dev-life a lot easier.

[szabesz]

just for cross reference:

https://processwire.com/blog/posts/processwire-2.5.3-master-2.5.4-dev/

and