Week Number calculation for OTL Overtime report if week starts from saturday and end on friday — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Week Number calculation for OTL Overtime report if week starts from saturday and end on friday

Summary:

Hi Team,

We need to calculate the weeknumber for a overtime card report. Week will start from saturday and end on friday
We need to pass "from week" and "to week" parameters for this report to fetch the data along with some other parameters

Example: for year 2025 jan 1st is falling in between the week so for year 2025 the week number will start from december 28th saturday and end on 3rd jan 2025

Week 1 : 28th december 2024 to 3rd jan 2025
Week 2: 4th jan 2025 to 10th jan 2025
so on .........

From Week and To Week Parameters format is YYYYWW

Example: Parameters to be passed in the below format

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!