Skip to main content
Topics#Data ManagementSeamus Knox의 질문
Seamus Knox 님이 #Data Management에 질문했습니다
2012년 7월 20일 오전 9:24

What formula can I use to make a date field a week number of the year?

I would like to give an invoice due date a week number for cashflow analysis.

 

Please help!

 

Thanks
답변 4개
  1. Robin Mead (RSC)
    2012년 7월 20일 오후 1:11
    MOD(FLOOR( (DATEVALUE(CreatedDate) - DATEVALUE("2006-01-01" ))/7),52)+1

     

    Just change CreatedDate to the correct field you want to calculate from.

     

    this isnt my fomula i found it here
답변을 작성하세요...
0/9000