Date Manipulation

[TimGrassam]

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

[ManojMishra]

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

[TimGrassam]

Thanks Manoj - that worked perfectly