RM Script: Reporting Date Range best practice

When creating a report, you often need to calculate the dates for the start and end of the reporting period, on month boundaries. Here is the current “best practice” way to achieve this:

[DateTime:
	format=yyyy-MM-dd,
	dateOnly=true,
	day=1,
	=>ReportingPeriodEnd
]
[DateTime:
	value={=ReportingPeriodEnd},
	addMonths=-1,
	=>ReportingPeriodStart
]

Result:

1 Like