158
I wrote the below compose formulas to try and filter out weekends. The first two worked (compose 1 & 3) but Compose 2 failed. Hoping someone can help me write it.
Compose - utcnow()
Compose 3 - dayOfWeek(formatDateTime(utcnow()))
Compose 2 - if( equals(dayOfWeek(formatDateTime(utcNow()),'4'),addDays(utcNow(),-3), addDays(utcNow(),-1)))
I ended up using @AbigailRausch formula, but I appreciate both responses. Thank you for your help.
@eliotcole 's solution looks perfect! But if you were also curious about why your current expression was failing, it looked like it 1) had the "4" in single quotes (which isn't needed due to comparing with an integer) as well as 2) the main culprit, parentheses slightly off. (That's why you got an error saying it expected more arguments than it got).
I think the expression is probably more like this:
| if(equals(dayOfWeek(formatDateTime(utcNow())),4),addDays(utcNow(),-3), addDays(utcNow(),-1)) |
Hi, @KhrystinaM, try this:
Share
Report
All responses (
Answers (
if(
equals(
dayOfWeek(utcNow()),
0
),
addDays(
utcNow(),
1
),
if(
equals(
dayOfWeek(utcNow()),
6
),
addDays(
utcNow(),
2
),
utcNow()
)
)That should add one day if today is Sunday, two if it is Saturday, and none for any other day.
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
