query on created_at with carbon

@hala, If you need to query Community created specific days before, you can use the ::whereDate function

Community::whereDate('created_at', Carbon::now()->subDays(3))

i tried it before i'm not using SQL so whereDate not implement in it

which Database driver were you using?

Mongo , and Jenssegers as a package

Sorry I couldn't be of help, I haven't used Mongo before...

this

Community::where('created_at', Carbon::now()->subDays(3)->toDateString())

doesn't actually do anything because you need to actuall run the query you created.

The query is executed with get() if you expect a collection, or first() if you only want one answer

you dont need to use the toDateString since eloquent handles carbon objects directly

$records=Community::where('created_at', now()->subDays(3))->get();

bear in mind that this query uses times, so actually the time of day the record was created is also considered

@snapey thank you for your answer yes i know about get and first i use them but i copy only the query in specific

actually after searching i got into this

      Community::where('created_at', '<',Carbon::now()->subDays(3))->pluck('_id', 'is_closed');

how can we help then if you show things out of context and dont include relevant information?