Level 1
Level 2
Sign in to Community
Learn more
Sign in to view all badges
Expand my Community achievements bar.
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"
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Views
Like
Replies
Likes