We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

DATE calculation

Longdaica
7 - Meteor
‎04-19-2018 02:22 AM

Hi

 

I am at 1/1/2017 => I convert it into 1 (week_number)

 

Is there  a way to do the calculation of date so when I said 1 week before 1/1/2017 is week "52" of last year?

 

1/1/2017 (date) - 1 (week) =  26/12/2016 (week 52)

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

1 REPLY 1
bharti_dalal
10 - Fireball
‎04-19-2018 02:54 AM

Hi @Longdaica,

I am attaching the solved workflow. Hope it helps. I hope you can do further on your own.

 

Week Number.yxzp
Reply
Live Office Hours
Labels
Top Solution Authors
View All