Go back to the full Messaging and Scheduled Tasks documentation
Overview
If needing to pass a dynamic date or date range to a target application, the Additional Parameters section can be used. Type the field in which the date value will be passed to and use one of the date parameters listed below.
All values are returned in ISO format (YYYY-MM-DD). If your application field is expecting a different format or is a numeric date field, append the parameter ‘dateformat=yyyy-MM-dd’ to the Additional Parameters box. For example; R001=${today}&dateformat=yyyy-MM-dd. This will tell the target application to translate the ISO date into the expected format.
Variables that return a range are separated by a space.
Fiscal dates are determined from the ‘fiscal_month’ setting in the mrcjava/WEB-INF/classes/mrc_runtime.properties file found on the m-Power server (i.e. fiscal_month=5).
Parameters
Assuming the current date is 2018-01-10, the date parameters would return the following values:
${today} — Current date (2018-01-10)
${tomorrow} — Tomorrow’s date (2018-01-10)
${yesterday} — Yesterday’s date (2018-01-09)
${thisweek} — Sunday to Saturday of the current week (2018-01-07 2018-01-13)
${thisweektodate} — Sunday of the current week to the current date (2018-01-07 2018-01-10)
${lastweektodate} — Sunday of the previous week to the current week day of the previous week (2017-12-31 2018-01-03)
${lastweek} — Sunday and Saturday of the previous week (2017-12-31 2018-01-06)
${nextweek} — Sunday to Saturday of the following week (2018-01-14 2018-01-20)
${thismonth} — First day of the current month to the last day of the current month (2018-01-01 2018-01-31)
${thismonthtodate} — First day of the current month to the current day of the current month (2018-01-01 2018-01-10)
${nextmonth} — First day of the following month to the last day of the following month (2018-02-01 2018-02-28)
${lastmonth} — First day of the previous month to the last day of the previous month (2017-12-01 2017-12-31)
${lastmonthtodate} — First day of the previous month to the current day of the previous month (2017-12-01 2017-12-10)
${thisquarter} — First day of the current quarter to the last day of the current quarter (2018-01-01 2018-03-31)
${lastquarter} — First day of the previous quarter to the last day of the previous quarter (2017-10-01 2017-12-31)
${thisyear} — First day of the current year to the last day of the cuBrrent year (2018-01-01 2018-12-31)
${nextyear} — First day of the following year to the last day of the following year (2019-01-01 2019-12-31)
${lastyear} — First day of the previous year to the last day of the previous year (2017-01-01 2017-12-31)
${thisyeartodate} — First day of the current year to the current date (2018-01-01 2018-01-10)
${lastyeartodate} — First day of the previous year to the current day of the previous year (2017-01-01 2017-01-10)
${thisquarterfiscal} — First day of the current fiscal quarter to the last day of the current fiscal quarter (2017-11-01 2018-01-31)
${lastquarterfiscal} — First day of the previous fiscal quarter to the last day of the previous fiscal quarter (2017-08-01 2017-10-31)
${thisyearfiscal} — First day of the current fiscal year to the last day of the current fiscal year (2017-05-01 2018-04-30)
${lastyearfiscal} — First day of the previous fiscal year to the last day of the previous fiscal year (2016-05-01 2017-04-30)
${thisyearfiscaltodate} — First day of the current fiscal year to the current date (2017-05-01 2018-01-10)
${lastyearfiscaltodate} — First day of the previous fiscal year to the current day of the previous fiscal year (2016-05-01 2017-01-10)
${todayEpoch} — Current date (12:00 AM Midnight) in Unix epoch time (1702360800)
${yesterdayEpoch} — Yesterday’s date (12:00 AM Midnight) in Unix epoch time (1702274400)
${firstofyear} — Returns the first day of the current year (2017-01-01)