cancel
Showing results for 
Search instead for 
Did you mean: 

Get last calendar day of the previous month

Choon_BoonLim
Level 2
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
2 REPLIES 2

AndrzejKaczor
Level 4
I usually use this formula:   AddDays(Today(), -ToNumber(FormatDate(Today(), ""dd"")))

VaibhavGarg
Level 2
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.