Weekend

[Jessi_Ortega]

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"

[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 · Accepted solution]

@Jessi_Ortega 

[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.