Hi guys, is there a way I can filter the next busi...
# suitescriptt
Tyn Guardian
03/04/2023, 12:17 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
h
heckytect
03/04/2023, 1:47 PMYou may try to use this formula for the filter
Copy code
TOMORROW - CASE WHEN TO_CHAR(TOMORROW, 'DY') = 'SAT' THEN 1 WHEN TO_CHAR(TOMORROW, 'DY') = 'SUN' THEN 2 ELSE 0 ENDheckytect
03/04/2023, 1:49 PMPut this formula as a value for the date you are trying to compare it to
heckytect
03/04/2023, 1:50 PMoperator should be "on or after"
t
Tyn Guardian
03/06/2023, 11:15 PMThanks Hector, I will try this on my end
Tyn Guardian
03/08/2023, 2:21 PMI got lost during the process, should be the "Tomorrow" variable is the Date today + 1?
2 Views