Answered

Exclude weekends from date field

(0) Share

Report

Posted on by KhrystinaM

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)))

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

eliotcole 4,363 Moderator on at

Like (2)

Report
Hi, @KhrystinaM, try this:

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.

Was this reply helpful? Yes No
Verified answer

AbigailRausch 48 on at

Like (2)

Report

@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))

Was this reply helpful? Yes No
KhrystinaM 158 on at

Like (1)

Report

I ended up using @AbigailRausch formula, but I appreciate both responses. Thank you for your help.
@eliotcole

Was this reply helpful? Yes No