Hi guys, is there a way I can filter the next busi...
# generalt
Tyn Guardian
03/04/2023, 12:21 PMHi guys, is there a way I can filter the next business day in saved search? I only see next business week and tomorrow 😐 TIA
c
Caroline
03/06/2023, 1:29 PMHi @Tyn Guardian,
I know that this solution is not ideal (as it doesn't work for Bank Holidays) but you can create a formula Text based on this condition: "if today is friday or saturday, then next day won't be a business day". Criteria would looks like this: "CASE WHEN (TO_CHAR({today}, 'Day') = 'Friday ') THEN 1 ELSE 0 END". Just need to add the WHEN scenario for Saturday (make sure not to forget the extra spaces after the day (exact value can be taken for the CSV export of the search results)). Good luck!
t
Tyn Guardian
03/06/2023, 11:15 PMthanks Caroline.. I will try this on my end :)
Tyn Guardian
03/08/2023, 2:59 PMhi Caroline, thanks for the help. I was able to get the result I wanted I use your formula and added some conditions :)
c
Caroline
03/08/2023, 3:13 PMIt looks great even if again a native relative reference would have been easier, well done!
keanu thanks 1
2 Views