topic Single Collection in Product Forum https://community.blueprism.com/t5/Product-Forum/Single-Collection/m-p/71171#M23776 Hi All, How to get all days in previous month into a Single Collection ? Mon, 04 Dec 2017 12:02:00 GMT Anonymous 2017-12-04T12:02:00Z Single Collection https://community.blueprism.com/t5/Product-Forum/Single-Collection/m-p/71171#M23776 Hi All, How to get all days in previous month into a Single Collection ? Mon, 04 Dec 2017 12:02:00 GMT https://community.blueprism.com/t5/Product-Forum/Single-Collection/m-p/71171#M23776 Anonymous 2017-12-04T12:02:00Z FirstDayThisMonth = MakeDate https://community.blueprism.com/t5/Product-Forum/Single-Collection/m-p/71172#M23777 FirstDayThisMonth = MakeDate(1, FormatDate(Today(), ""MM""), FormatDate(Today(), ""yyyy"") Then work backwards via AddDays([FirstDayThisMonth], -1) Mon, 04 Dec 2017 16:00:00 GMT https://community.blueprism.com/t5/Product-Forum/Single-Collection/m-p/71172#M23777 John__Carter 2017-12-04T16:00:00Z