Hi @Kathy Leeman‚ and @Nelson Soans‚ , I was excited to find a text mode
calculation to show the week number. Unfortunately, when I paste this
code into a column in a task report or view it only returns "1" or "0".
Any suggestions for what I do wrong
here?displayname=Testtextmode=truevalueexpression=ROUND((((DATEDIFF({plannedStartDate},DATE(CONCAT("1/1/",YEAR({plannedStartDate}))))+1)-(8-DAYOFWEEK(DATE(CONCAT("1/1/",YEAR({plannedStartDate})))))-DAYOFWEEK({plannedStartDate}))/7)+2,0)valueformat=H...