nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Convert date to week number of that year

Longdaica

Hi all

i used this formula to convert date to week. But something is wrong

ToNumber(DateTimeFormat([DATE],'%U'))+1 <= I have taken from this forum

I found out that when i try to convert 29/12/2017 , it gave me week 53 of 2017

but when i tried different tool on the internet, it gave me week 52..... I am pretty sure that 2017 is not a leap year !!!!

wweekk.png

Tips and Tricks

Date Time

Transformation

Accepted answers

BenMoss

There is no single answer to your question, the notion of week numbers depends on the system you are trying to apply.

I've found this one which was found in this thread: https://community.alteryx.com/t5/Data-Preparation-Blending/Calculating-Week-Number-using-DateTimeFormat-is-incorrect/td-p/46192

PadLeft(ToString(FLOOR(DateTimeDiff(DateTimeAdd([Field1],4-Switch(DateTimeFormat([Field1],"%a"),7,"Mon",1,"Tue",2,"Wed",3,"Thu",4,"Fri",5,"Sat",6),"days"),DateTimeParse(ToString(ToNumber(DateTimeFormat(DateTimeAdd([Field1],4-Switch(DateTimeFormat([Field1],"%a"),7,"Mon",1,"Tue",2,"Wed",3,"Thu",4,"Fri",5,"Sat",6),"days"),"%Y")))+'-01-01',"%Y-%m-%d"),"days")/7)+1),2,"0")