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
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.