Get last calendar day of the previous month
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
10-09-18 12:30 PM
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
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
10-09-18 03:45 PM
I usually use this formula:
AddDays(Today(), -ToNumber(FormatDate(Today(), ""dd"")))
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
10-09-18 04:01 PM
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.
