Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
The Expert Exam is now live online! Read about the specifics and what it took to bring it to life in the blog by our very own Elizabeth Bonnell!
SOLVED

Return the friday date for each week

Highlighted
7 - Meteor

Hi All,

 

I have col. A (Regulatory Date) and I need to add a new column named 'Forecast Week Date' which returns the Friday for each date I have in column A. 

 

i.e if column A= 6-Oct-20 then col. B= 9-Oct-20

if column A= 28-Sep-20 then col. B= 2-Oct-20 etc..

 

Any suggestions?

 

Many Thanks in advance,

Gaetano

Highlighted
15 - Aurora

Hi @Gaetano_B 

 

Here is a workflow for the task.

 

Output: (use a select tool keep only required columns)

atcodedog05_0-1602771107040.png

 

 

Workflow:

atcodedog05_1-1602770879387.png

 

Hope this helps 🙂


If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

Highlighted
16 - Nebula
16 - Nebula

I suggest a formula tool with the expression:

 

DateTimeAdd([Start],5-ToNumber(DateTimeFormat([Start],"%w")),"days")

 

 

 Have attached a sample

Highlighted
15 - Aurora

Happy to help 🙂 @Gaetano_B 

 

Cheers and Happy Analyzing 😀

Labels