How to get count of non existing values from eloquent?

[ruvaifa-masood]

Hi there,

Is there any way to get count of non existing values from eloquent?

For example:

$count = Post::whereBetween('created_at', ['from date', 'to date'])->count();

How can I get the count of those posts which doesn't exist between the mentioned from and to dates?

[dennisprudlo]

Do you mean all posts that weren't created in the specified range? Like so?

$count = Post::where('created_at', '<', $fromDate)->where('created_at', '>', $toDate)->count();

[ruvaifa-masood]

Yes, but there should be a method in eloquent to get the count of non existing values.

[hotmeteor]

Wouldn't you just get a count of dates for that range and then subtract the number that exist?

[ruvaifa-masood]

It may cause some performance issues. I think it would be better if it calculates within the database layer.

[dennisprudlo]

Instead of whereBetween you could use whereNotBetween.