Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Add field for week commencing from a list of dates

JOliver251
7 - Meteor

Hi,

 

If I have a list of dates and i want to add a new field which is the week commencing relating to that date, what's the simplest way to achieve this? The dates will change every time the workflow is used but for example:

 

01/10/2018

02/10/2018

03/10/2018

etc. for the rest of the month

 

Thanks!

4 REPLIES 4
ponraj
13 - Pulsar

Can you share the sample output ?

JOliver251
7 - Meteor

I was thinking something like this (it would need to work for any month or year):

image.png

ponraj
13 - Pulsar

Attaching sample workflow for your case. Hope this is helpful. 

 

WorkflowWorkflow

JOliver251
7 - Meteor

Perfect thank you!

Labels