Message of the day:
Welcome. Latest release: https://www.silverstripe.org/download Community Forum: https://forum.silverstripe.org Features: https://forum.silverstripe.org/c/feature-ideas Archive: https://slackarchive.silverstripe.org
If you have any SilverStripe related questions, please supply the version of Framework you're using.
Did you flush? 🚽 =
Archive temporarily at https://archive.codingplayground.nl (redirect)
yeah, as cameron said. Either use the search filters, or raw "where" statements, although that don't won't be portable
Ok - Can you help me with the syntax? I don´t really get it
Either way you'd do the same comparison.
But that's not really relevant I guess lol
I generally prefer using SSDateTime because it's easier to deal with correct orders when objects have the same date
Is NewOfDate SSDateTime?
Iirc you'd use two filters. LessThanOrEqual, GreaterThanOrEqual, and you need to input Date +/- 10 days as one of the values
I am really stuck - How can I filter by datediff? i have a field called NewOfDate I want to list objects that have NewOfDate greater than yesterday and not greater than 10 days from now
Might be worth nudging dnadesign over that -seems like an oversight... but maybe by design?