Platform: Extended Support for Date-Relative Parameters

MYOB Acumatica 2025.1 introduces support for relative date selection in import and export scenarios and automation schedules.

Support of Relative Dates in Integration Scenarios

In previous versions of MYOB Acumatica, if a customizer wanted to specify a relative date in an import or export scenario, they needed to select the Is Relative check box and then select a date in the Value column. The Is Relative check box was available in the following locations:

In MYOB Acumatica 2025.1, this check box has been removed. To select a relative date, the customizer can now select one of the following standard options in the Value column of any of the above-listed tabs:

  • @Today: The business day.
  • @WeekStart and @WeekEnd: The start and end, respectively, of the current week. The start and end of the week are determined according to the default system locale or the locale the user has selected when signing in to MYOB Acumatica.
  • @MonthStart and @MonthEnd: The start and end, respectively, of the current month.
  • @QuarterStart and @QuarterEnd: The start and end, respectively, of the current quarter.
  • @PeriodStart and @PeriodEnd: The start and end, respectively, of the current financial period.
  • @YearStart and @YearEnd: The start and end, respectively, of the current calendar year.

The customizer can also specify one of the options listed above followed by + or - and the number of days to be added or subtracted from that date. For example, the customizer could do the following:

  • Indicate the previous day by selecting @Today in the Calendar dialog box (see Item 1 in the following screenshot) and then type -1 in the Value column (Item 2).

    The customizer opens this dialog box by clicking the Calendar button in a date box (Item 3).

  • Specify a relative date in the past or in the future by specifying values such as @Today-2 or @Today+4.
Figure 1. Selection of a relative date on the Import Scenarios form


Attention: On the Source Restrictions tab of the Import Scenarios form, the Calendar dialog box is available for a field only if this field has DateTime selected in the Data Type column on the Data Providers (SM206015) form.

Support of Relative Dates in Automation Schedules

In previous versions of MYOB Acumatica, the customizer needed to perform similar actions to those described in the previous section to select relative dates in automation schedules on the Conditions and Filter Values tabs of the Automation Schedules (SM205020) form.

In MYOB Acumatica 2025.1, the Relative check box has been removed from these tabs, and standard date-relative options have been added. The customizer can now specify a relative date in the same way as the previous section described.