Loading

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

Veröffentlichungsdatum: Apr 29, 2025
Aufgabe
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? 
Schritte
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.
Nummer des Knowledge-Artikels

001456835

Anhänge

StartDay_EndDay_Weeks.twbx

2412 KB

 
Laden
Salesforce Help | Article