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

Ageing with Weeks

praneshsapmm
8 - Asteroid
‎04-04-2022 02:29 AM

Hello,

 

I have requirement to calculate difference between two weeks in two different years as shown below . Can someone help with solution .

 

Week1 : 201515 (Year+week)

Week2 : Current week = 14 

 

Result Ageing in days : (Week2 - Week1 )*7

 

Thanks.

Labels:
Reply
0 Likes
1 REPLY 1
PhilipMannering
16 - Nebula
16 - Nebula
‎04-04-2022 02:57 AM

Hi @praneshsapmm 

 

Does this do what you need?

PhilipMannering_0-1649066252314.png

 

Week difference.yxmd
Reply
Community Live
Live Cloud Quest Solve
Labels
Top Solution Authors
View All