I am trying to create dynamic views in Outlook Tasks based on Due Date. I would like to filter out content that is Due more than 30 days in the future. There are of course some other criteria which seem to work appropriately, but this seems to be particularly tricky.
There are default options for "Due Date" "in the next 7 days" or "in the next week" but those won't meet my needs.
I have tried some values using the Due Date "on" , but have been so far unsuccessful. In the screenshot below, you can see the canned "Due Date in the next 7 days" display, as well as my attempt with "Due Date on t+30" indicating today + 30 days. https://i.sstatic.net/6RWGX.png
I also have access to this SQL version of the filter, and I feel that may be the way to go, but I'm not familiar with the schemas. In this screenshot, you can see that I've included two of my other criteria (Status not Completed, and In Folder does not contain "Personal"), but I've struggled to find information linking these properties in Outlook to the schemas.microsoft.com identifiers. https://i.sstatic.net/qlh2V.png
It seems I don't not have the reputation to enter screenshots :/