Hmm... don't think so...
Comment actions
Post
Follow
Get Frist/Last Working day of Month
Hi,
Is it possible to get the first and/or last working day of a given month as a date object?
For example:
FirstWorkingDay(Today()) will return: 2017-01-02
LastWorkingDay(Today()) will return: 2017-01-31
But, essentially "Today()" could be any date object.
Please sign in to leave a comment.
3 comments
Date
Votes
To provide some more background: currently, we have a data validation rule that prevents users from logging time for previous months. We were thinking we could give our users a grace period, say... 1 or 2 working days.
Logically, this would be the first and/or second working day of the month, so long as the timesheet entries are for the previous month.
Comment actions
I can't think of a way to do this
Comment actions