Umb 10.6.1 Can anyone spot what the issue with this line is please?

List<WeeklyEventItem> weeklyEventList = CurrentPage.Children<WeeklyEventItem>().Where(x => x.RepeatableStartDate.Date >= DateTime.Today).ToList();

It returns everything if I leave the Where clause out. But won't filter on the date.

The datetime that you get from the childpages, is it a utc date or a local date? I believe datetimes are transformed in someway during comparison when one is utc and the other isn't

It's just an Umbraco DateTime

Understandable, but you're using 'today' to compare against, which has a property 'kind' set as 'local'. If the 'kind' property of the datetime from 'RepeatableStartDate' is not 'local' as well, a transform is applied before comparison

Interesting. I've just tried:-

RepeatableStartDate.Date >= DateTime.Today

RepeatableStartDate.Date >= DateTime.UtcNow

RepeatableStartDate.Date >= DateTime.Now

RepeatableStartDate >= DateTime.UtcNow

RepeatableStartDate >= DateTime.Now

And have tried removing the "=" so it's just ">" And converting both sides to Ticks. Nothing works 😦

Alright, now just so I fully comprehend, what is the outcome that you get? I'm assuming you're looking for all items with a RepeatableStartDate in the future, including today. Do you get nothing at all? or are you missing certain items that you expected in your output? And just as an inspiring anecdote: I had pulled open a project once that hadn't been touched for a while and dates also didn't seem to work anymore. Turned out I had forgotten to update the dates in the content, because all the dates in the content had expired.

Lol, yeah, had that one before 🙂 You're correct, in that I want all the nodes with a RepeatableStartDate in the future, incl. today. I get 0 out. There are over 700 records with dates ranging from 2019 to 2024.