I suppose you could use StartDate = createDateTime(2022, 6, 1, 0, 0, 0) FirstDayNextMonth = createDateTime(2022, 7, 1, 0, 0, 0) EndDate = addDays(FirstDayNextMonth, -1)