What to Do If Your D365 Business Central OData Date Query Restriction Fails with Error

In this video, we troubleshoot a common issue in SmartConnect 21 where an OData date filter fails with a formatting error. The goal is to filter for data created after "yesterday" at midnight using a global variable. While the query looks correct, it fails due to a missing 'Z' at the end of the datetime string. We’ll show how to fix the error by properly formatting the date and setting it in a .NET scripting task. If you'd like to read the help article that goes with this, click here.