Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Change the date of Specific Days

masfouaa
6 - Meteoroid

Hello everybody 

 

I need a formula or tool can select specific day to change them like below  statements: 

 

  • "if the day is Friday then the date will decrease by 1 day" 
  • "if the day is Saturday then the date will decrease by 2 days"

 

 

2 REPLIES 2
binuacs
21 - Polaris

Switch(DateTimeFormat([Due Date],"%A"),[Due Date],"Friday",DateTimeAdd([Due Date],-1,"days"),"Saturday",DateTimeAdd([Due Date],-2,"days"))

 

 

Spoiler
binuacs_0-1639032659923.png

 

masfouaa
6 - Meteoroid

Incredible!

 

thanks a lot.. ^^

Labels
Top Solution Authors