Expand my Community achievements bar.

Join us LIVE in San Francisco on November 14th for Experience Makers The Skill Exchange. Don't miss out on this free learning event!

Week Number date display

Avatar

Level 10

3/9/17

I want to be able to display a date as a week number on a report. This should be the ISO week number. Instead of a date displayed as "March 9, 2017", I'd like to have the option to display it as "Week 10"

1 Comment

Avatar

Level 6

12/7/23

valueexpression=IFIN(DAYOFWEEK(CONCAT("1/1/",YEAR({entryDate}))),1,6,7,CEIL(DIV(DATEDIFF({entryDate},CLEARTIME(CONCAT("1/1/",YEAR({entryDate})))),7)),SUB(CEIL(DIV(DATEDIFF({entryDate}),CLEARTIME(CONCAT("1/1/",YEAR({entryDate}))),7)),1))
valueformat=HTML

 

This accounts for Workfront recording Sunday as day 1 where the ISO week number uses Monday as Day 1