Expand my Community achievements bar.

Don’t miss the Workfront AMA: System Smarts & Strategic Starts! Ask your questions about keeping Workfront running smoothly, planning enhancements, reporting, or adoption, and get practical insights from Adobe experts.

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