Adding a Date line restriction in SmartConnect

Today's task is to add a date valued line restriction in a SmartConnect map

Restated:

I'm querying the Business Central Posted_Sales_Invoice API, and I only want to bring in recent documents. 

In the field mapping window, click on the 'restrictions' button, and code something like this:

dim newDate as Date
newDate =  fn.DAYADD(GlobalRunDate,-30)
 
if  _POSTING_DATE > newDate then
    return true
else
    return false
end if

RealWorldCode gives developers practical, real‑world solutions with clean, working code — no fluff, no theory, just answers.
Links
Home
Knowledge Areas
Sitemap
Contact
Et cetera
Privacy Policy
Terms and Conditions
Cookie Preferences