
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Last working day of month
Hello.
I am trying to add a flag to my script where i want the last day of the month excluding holidays and weekend.
If the last day of the month is on suturday then i want friday to be my last day.
How do I do that without using monthend fuction?
FPS
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Try this:
firstworkdate(Monthend([Your Date Field]),1) AS Date
Also, you can add holidays as a third parameter, for instance for a current month I added 5/30/2022 and 5/31/2022 and as a result the last working day in May is 5/27/2022 - last Friday.
firstworkdate(Monthend(today()),1, '5/30/2022', '5/31/2022') AS Date
Regards,
Vitalii
If it's possible please mark correct answers as "solutions" (you can mark up to 3 "solutions").

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Try this:
firstworkdate(Monthend([Your Date Field]),1) AS Date
Also, you can add holidays as a third parameter, for instance for a current month I added 5/30/2022 and 5/31/2022 and as a result the last working day in May is 5/27/2022 - last Friday.
firstworkdate(Monthend(today()),1, '5/30/2022', '5/31/2022') AS Date
Regards,
Vitalii
If it's possible please mark correct answers as "solutions" (you can mark up to 3 "solutions").
