Hi all,
Is there any way to subset (in order to create a conditional) Working days vs non working days. I have a rough work around that can so weekends vs weekdays, but ideally would want to include bank holidays.
Thanks
Bump? This never got an answer, so I assume there isn’t a way to do this?
Currently using a work around of
IF DotW ‘Starts’ with S = Weekend
IF DotW ‘Doesn’t Start’ with S = Weekday
Not having public holidays is causing issues
I feel like there might be something you can do with the “count working days between 2 date fields” composite…
is it possible to do if(count working days between dateCreated and dateCreated = 1), then its not a bank holiday or a weekend, else it is a non-working day
or is it if(count working days between dateCreated and (dateCreated+1) = 1), then its not a bank holiday or a weekend, else it is a non working day
1 Like
I think i might have a solution for a given date:
composite 1: given date minus 1 day
composite 2: working days between 2 date fields (from composite 1 to given date)
if composite 2 = 1 then its a working day
if composite 2 = 0, then its a non working day
2 Likes
