Hello,
I have a table with Dates
2014-12-22 |
2014-12-29 |
2015-01-05 |
i use this formular to calculate calendarweek
DateTimeFormat([Date],"%W.%Y")
Then i used the formular DateTimeFormat(DateTimeAdd([Date],7,"days"),"%W.%Y")
But didnt worked the way i want to
My output is here
date | DateTimeFormat([Date],"%W.%Y") | DateTimeFormat(DateTimeAdd([Date],7,"days"),"%W.%Y") | https://www.timeanddate.com/date/weeknumber.html# |
2014-12-22 | 51.2014 | 52.2014 | 52.2014 |
2014-12-29 | 52.2014 | 01.2015 | 01.2015 |
2015-01-05 | 01.2015 | 02.2015 | 02.2015 |
... | ... | ... | ... |
2015-12-28 | 52.2015 | 01.2016 | 53.2015 |
2016-01-04 | 01.2016 | 02.2016 | 01.2016 |
The last column is my desired output calculated with https://www.timeanddate.com/date/weeknumber.html#
Do you know how to get the output i want?
It seems like alteryx calculate calendarweek wrong befor 2016?
Is there a way to calculate it like in excel?
(attached a textfile with some dates i use)
Solved! Go to Solution.
I think this is what you're looking for: