How to Get The Week Number of Month From Date in Salesforce?
Sample Code :
public Integer weekOfMonth(Date todaysDate){
Integer weekCount = 0;
Integer startWeekResidue = 0;
Integer endWeekResidue = 0;
//Calculating startWeekResidueDate dt = todaysDate.toStartOfMonth().addDays(-1);Date dtFirstWeekend = dt.toStartOfWeek().addDays(6);startWeekResidue = dt.daysBetween(dtFirstWeekend);
//Calculating endWeekResidueDate dtLastWeekend = todaysDate.toStartOfWeek().addDays(-1);endWeekResidue = dtLastWeekend.daysBetween(todaysDate);
//Counting the weeksweekCount = (todaysDate.day() - (startWeekResidue + endWeekResidue))/7;weekCount += (startWeekResidue > 0 ? 1:0)+(endWeekResidue > 0 ? 1:0);System.Debug('Week Number: ' + weekCount);
return weekCount;
}

Follow Us