topic Date Manipulation in Product Forum https://community.blueprism.com/t5/Product-Forum/Date-Manipulation/m-p/86564#M37402 Hi Anyone know of a way to get the last day of the previous month in DD-MMM-YYYY format, using Blue Prism, easily? Thanks Fri, 27 Jun 2014 22:19:00 GMT TimGrassam 2014-06-27T22:19:00Z Date Manipulation https://community.blueprism.com/t5/Product-Forum/Date-Manipulation/m-p/86564#M37402 Hi Anyone know of a way to get the last day of the previous month in DD-MMM-YYYY format, using Blue Prism, easily? Thanks Fri, 27 Jun 2014 22:19:00 GMT https://community.blueprism.com/t5/Product-Forum/Date-Manipulation/m-p/86564#M37402 TimGrassam 2014-06-27T22:19:00Z Hi Tim, https://community.blueprism.com/t5/Product-Forum/Date-Manipulation/m-p/86565#M37403 Hi Tim, You can try this in the calculation stage FormatDate(AddDays(MakeDate(1, FormatDate(Today(), ""MM""), FormatDate(Today(), ""yyyy"")), -1),""dd-MMM-yyyy"") and then assign it to a text. Regards, Manoj Mon, 30 Jun 2014 14:08:00 GMT https://community.blueprism.com/t5/Product-Forum/Date-Manipulation/m-p/86565#M37403 ManojMishra 2014-06-30T14:08:00Z Thanks Manoj - that worked https://community.blueprism.com/t5/Product-Forum/Date-Manipulation/m-p/86566#M37404 Thanks Manoj - that worked perfectly Fri, 18 Jul 2014 15:38:00 GMT https://community.blueprism.com/t5/Product-Forum/Date-Manipulation/m-p/86566#M37404 TimGrassam 2014-07-18T15:38:00Z