Week Number date display | Community
Skip to main content
C
CustomerSu
New Participant
March 9, 2017
Archived

Week Number date display

  • March 9, 2017
  • 1 reply
  • 320 views

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 reply

    GrahamJarrett
    GrahamJarrett
    New Participant
    December 7, 2023

    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

    Terms & ConditionsAccessibility statement

    Loading footer...