SAP Business One SQL (B1WebAPI) Connector updated

SAP Business One SQL (B1WebAPI) Connector version 7.12.0 adds support for date variables such as {Today} and {Today-7} into workflow trigger filters.

Date variables may be added to workflow trigger filters that support dates, and include:

{StartOfPreviousMonth}
{EndOfPreviousMonth}
{StartOfCurrentMonth}
{EndOfCurrentMonth}
{Today}
{Today+n} (where “n” is a number) ex: to set a filter to a week from now, use: {Today+7}
{Today-n} (where “n” is a number) ex: to set a filter to a week ago, use: {Today-7}
{Today.DateTime} for today’s date including time component. For example, in a parameter where time component is needed.

Except in Parameter values, date filters use the appropriate format (date or date/time) as needed for that filter. Parameters are “Date only” by default, with “Date and Time” available using the option {Today.DateTime}.

For more connector details, see SAP Business One SQL (B1WebAPI) Connector Reference.