linq query subtracting two datetimes not working with mongodb, c# and linq

Question

I'm having trouble with a fairly simple query, using linq and mongodb:

List<GiactEnrichment> giactEnrichments = GiactEnrichmentClient.FindAll(x => x.ApplicationId == applicationId && (DateTime.Now.Subtract(x.QueryValidationDate).TotalDays <= days));

It gives me this exception:

{"2/4/2021 4:20:49 PM.Subtract({document}{QueryValidationDate}).TotalDays is not supported."}

After a bit of research i found this page: Link and they said that mongodb does not support these kinds of queries. Is there something i'm missing?

question from:https://stackoverflow.com/questions/66052535/linq-query-subtracting-two-datetimes-not-working-with-mongodb-c-sharp-and-linq

Answer 1

Waitting for answers