How to Get The Week Number of Month From Date in Salesforce?

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

Posted By : Sudeer Kamat Date :

view_module Related

label Labels

Comments 0