https://community.blueprism.com/t5/Product-Forum/Get-last-calendar-day-of-the-previous-month/m-p/81160#M32770 Does anyone know how do I get the last calendar day of the previous month? I have looked at the Date and Time Manipulation object, and there is no action for this.   Thanks Mon, 10 Sep 2018 11:30:00 GMT Choon_BoonLim 2018-09-10T11:30:00Z https://community.blueprism.com/t5/Product-Forum/Get-last-calendar-day-of-the-previous-month/m-p/81160#M32770 Does anyone know how do I get the last calendar day of the previous month? I have looked at the Date and Time Manipulation object, and there is no action for this.   Thanks Mon, 10 Sep 2018 11:30:00 GMT https://community.blueprism.com/t5/Product-Forum/Get-last-calendar-day-of-the-previous-month/m-p/81160#M32770 Choon_BoonLim 2018-09-10T11:30:00Z https://community.blueprism.com/t5/Product-Forum/Get-last-calendar-day-of-the-previous-month/m-p/81161#M32771 I usually use this formula:   AddDays(Today(), -ToNumber(FormatDate(Today(), ""dd""))) Mon, 10 Sep 2018 14:45:00 GMT https://community.blueprism.com/t5/Product-Forum/Get-last-calendar-day-of-the-previous-month/m-p/81161#M32771 AndrzejKaczor 2018-09-10T14:45:00Z https://community.blueprism.com/t5/Product-Forum/Get-last-calendar-day-of-the-previous-month/m-p/81162#M32772 FormatDate(AddDays(MakeDate(1, ToNumber(FormatDate([CurrentDate], ""MM"")), ToNumber(FormatDate(AddMonths([CurrentDate], 1), ""yyyy""))), -1),""ddd"")   Try this expression will give your result, Supply date in mm/dd/yyyy.     Mon, 10 Sep 2018 15:01:00 GMT https://community.blueprism.com/t5/Product-Forum/Get-last-calendar-day-of-the-previous-month/m-p/81162#M32772 VaibhavGarg 2018-09-10T15:01:00Z