Weekend

Hello,
I am trying to make a flow where it checks the delivery date and checks if the date is today, if it is today it outputs True Else False.

IF DateTimeFormat([Delivery Date], "%Y-%m-%d") == DateTimeFormat(DateTimeToday(), "%Y-%m-%d") THEN "True" ELSE "False" ENDIF

This works but now I also need it to check if the date falls on the weekend and if it does I want the output to say "Weekend"

Output

Accepted answers

binu_acs

@Jessi_Ortega

WeekDay_Check_271123.yxmd

All comments

Raj

@Jessi_Ortega
Reffer this link - https://community.alteryx.com/t5/Engine-Works/DateTime-Functions-Cheat-Sheet/ba-p/844353

were you cab use %A to check the day to apply the flag.

Hope this help.

binu_acs

@Jessi_Ortega

WeekDay_Check_271123.yxmd

Jessi_Ortega

That worked, thank you. How about if its a holiday?

CoG

For holidays you would need a external dataset that contains all holidays you want to consider. You can then do a join by date, every row that joins was a holiday and everything that doesn't - wasn't.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703