Solved! Go to Solution.
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Replies
Total Likes
This worked for me like a charm @Kathy Leeman‚, and, it was elegant :)
Views
Replies
Total Likes
Views
Replies
Total Likes
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=Test
textmode=true
valueexpression=ROUND((((DATEDIFF({plannedStartDate},DATE(CONCAT("1/1/",YEAR({plannedStartDate}))))+1)-(8-DAYOFWEEK(DATE(CONCAT("1/1/",YEAR({plannedStartDate})))))-DAYOFWEEK({plannedStartDate}))/7)+2,0)
valueformat=HTML
I'm still working on my text mode skills, but this one is too complex for me...
Kind regards,
Femke
Views
Replies
Total Likes
hey @Femke Crijns‚ , your formula is exactly the same as what I used in my report based on Kathy' suggestions. It worked like a charm for me but not sure why you are seeing the 1s and 0s!!
This worked great for me - or so I thought...
i was trying to get the FISCAL week of the year, with the fiscal year starting on 1/3
worked great for US formatted dates, but when the user has their browser set to another language that formats the date as DD/MM/YY, it reads "1/3/" with 3 as the month and 1 as the day and flubs the formula. I changed it back to 1/1 and used some different math to account for the first week of the year date shift.
just wanted to through that FYI out here
Views
Replies
Total Likes
Hi all,
I'm still struggling with the week numbers and looking for some help.
I see the week numbers now, but the week starts on Sunday in this formula. I have tried several changes in the formula, but I can't find the value to change to start a new week on Monday.
And in 2022, the week numbers are correct (except for Mondays), but in 2023 it counts one week less than it should be.
23 September 2023 is week 38 instead of week 37.
Hopefully, someone with great textmode skills could help me out here ;-).
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies
Views
Likes
Replies
Views
Likes
Replies