Loading

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

Udgivelsesdato: Apr 29, 2025
Opgave
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? 
Trin
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.
Vidensartikelnummer

001456835

Vedhæftede filer

StartDay_EndDay_Weeks.twbx

2412 KB

 
Indlæser
Salesforce Help | Article