Loading

How to Display Start Day And End Day Of Week Instead Of Week Number

게시 일자: Apr 29, 2025
과업
How to show the range of week by the start day and the end day of the week, such as 12/30 - 1/5, instead of the week number for a date field? 
단계
Create a calculated field named as Start Day - End Day of Week which contains the following calculation. 
STR(MONTH(DATETRUNC('week',[Order Date])))+"/"+
STR(DAY(DATETRUNC('week',[Order Date])))
+ " - " +
STR(MONTH(DATETRUNC('week',DATEADD('week',1,[Order Date]))-1))+"/"+
STR(DAY(DATETRUNC('week',DATEADD('week',1,[Order Date]))-1))
The above calculation is demonstrated in the attached workbook.
Knowledge 기사 번호

001456835

첨부 파일

StartDay_EndDay_Weeks.twbx

2412 KB

 
로드 중
Salesforce Help | Article