Edit Question - KnowledgeHub

Title Body

public class ScheduledEvent : Event { public DateTimeOffset StartDateTime { get; set; } } StartDateTime = 5/27/2013 2:09:00 AM +00:00 representing 05/26/2013 07:09 PM PST What's recorded in MongoDB: db.ScheduledEvent.find().toArray()[ { "_id": BinData(3, "ZE2p31dh00qb6kglsgHgAA=="), "Title": "Today 26th at 7:09pm", "Length": "00:00:00", "MoreInformation": "http://1.com", "Speakers": [{ "_id": BinData(3, "ndzESsQGukmYGmMgKK0EqQ=="), "Name": "Mathias Brandewinder" } ], "Location": { "_id": BinData(3, "AAAAAAAAAAAAAAAAAAAAAA=="), "Name": "Somwhere " }, "Organizers": [{ "_id": BinData(3, "AAAAAAAAAAAAAAAAAAAAAA=="), "Name": null }], "CreatedOn": [ NumberLong("635052144104050898"), 0 ], "StartDateTime": [ NumberLong("635052173400000000"), 0 ] } ] I realize that StartDateTime is stored as Ticks in MongoDB. var dateMarker = DateTimeOffset.UtcNow; var nextDay = dateMarker.AddDays(1); This query does not work: var today = EventRepoistory .All() .Where(z => z.StartDateTime >= dateMarker && z.StartDateTime < nextDay) .OrderByDescending(z => z.StartDateTime) .ToList(); I have added a query display to the Mongo C# driver which shows the following query: { "$query" : { "StartDateTime" : { "$gte" : [NumberLong("635052168609734070"), 0], &quo

Tags (comma-separated) Cancel