Filtering of date does not work as expected

[MPSharp]

[evan-scales]

Start end end time are stored as UTC times in the db. So that first posts start time is 4/1/24 0:44 AM.

To fix this we need to add/subtract time here based on the users timezone. Since we are coming from EDT 4 hours should be added to this startAfterDateTime Something similar should probably be done for query.EndOnOrBeforeDate right below.

Or maybe if we pass a DateTime to the api instead of a DateOnly, then the DateTime can be localized already. So in our case it should be sending 4/1/24 04:00 AM UTC to the api for the start date

I think the filtering by time should be fine because we localize the time before sending it to the api.