MODX Community

Pdoresources where createdon syntax help

hello, I am trying to limit the results i get with pdoresources, Im trying to limit the results by the created on date

here is my syntax

&where=`{"createdon:=":"' . $dateFrom . '"}`

but it does not work, I am guessing because the createdon result is not the same as the date i get from the form which is yy/mm/dd

how do I format my where clause to make this work? does anyone know?

also how do I limit by tag on an article? is that possible?

i would appreciate any help

1 Like

I should mention I am using the articles extra

1 Like

Try:

&where=`{"createdon:=>":"' . $dateFrom . '"}`

or this if $dataFrom is not a Unix timestamp:

&where=`{"createdon:=>":"' . strtotime($dateFrom) . '"}`
2 Likes

many thanks, works great

1 Like

I’m glad it worked. Thanks for reporting back. :slight_smile:

1 Like