03-25-2019 11:20 AM
The following expression library can be used to generate the start date and end date of the previous month in several formats.
{
// Convert the given Date-with-time object into a Date with only the year and month
to_month_date: x => Date.UTC(x.getFullYear(), x.getMonth() - 1),
// Get the start of the previous month based on the given date or the current time if no parameters are given
prev_month_start: x => this.to_month_date((x || Date.now()).minusMonths(1)),
// Get the end time of the previous month based on the given date or the current time if no parameters are given
prev_month_end: x => this.to_month_date((x || Date.now()).withDayOfMonth(1)).minusSeconds(1),
prev_month_start_string: x => this.prev_month_start(x).toString().split('T')[0],
prev_month_end_string: x => this.prev_month_end(x).toString().split('T')[0],
prev_month_start_epoch: x => this.prev_month_start(x).getTime(),
prev_month_end_epoch: x => this.prev_month_end(x).getTime()
}