Scenario:
How to get the month from a weekly time sheet.
The weekly timesheet has a body-level week date. Based on this week date the weekdays are shown in the line level time item sublist. When a week includes the days of 2 different months how do we get these two different months from the line level?
Solution
- The weekly timesheet record setup has been reviewed.
- As per my understanding, the enter time sublist contains only seven days.
- So you can add 7 days with the week of the date.
- Then check the week of the date month and plus 7 days month. Identify months from both objects. If the month value is the same that means day are included in the same month, else days are included in a different month.