How to compare only date of dateTime while filtering from mongo in c#?

Question

My date time property defined in my model class named Recommendation is

public DateTime? DueDate { get; set; }

I am trying to filter and retrieve data from mongo where the field DueDate matches the current date only not including time.

I made a filter expression for querying on mongo.

var dateFilter = Builders<Recommendation>.Filter.Eq(x => x.DueDate, DateTime.Now)

DateTime.Now also returns the date with a timestamp.

Also in mongo, the DueDate field value is 2022-12-08T05:00:00.000+00:00

How can I modify the filter query above to filter and fetch records from mongo based on date only and not timestamp?

gunr2171 · Accepted Answer · 2022-12-07 22:06:40Z

2

You could convert them to strings:

var dateFilter = Builders<Recommendation>.Filter.Eq(x => x.DueDate.ToString("yyyyMMdd"), DateTime.Now.ToString("yyyyMMdd");

No promises on the performance of this.

edited Dec 7, 2022 at 22:06

gunr2171

17.7k26 gold badges68 silver badges102 bronze badges

answered Dec 7, 2022 at 21:47

Vic F

1,4691 gold badge15 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Vipul Prakash Over a year ago

When applying on x.DueDate.ToString("yyyyMMdd") it is giving error that "No overload for method ToString takes 1 argument". Also, DueDate is nullable as well -DateTime? . It is working fine on DateTime.Now though but only gives an error on DueDate. It's only accepting ToString() without arguments on DueDate part

Vic F Over a year ago

If they are Nullable, it might be: x.DueDate.GetValueOrDefault().ToString("yyyyMMdd")

Collectives™ on Stack Overflow

How to compare only date of dateTime while filtering from mongo in c#?

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related