Using Aprils Timesheet App - https://www.youtube.com/watch?v=qqEHiB6v_i4
Dropdown field is showing the date on the picklist but whenever the current Month gets ended and next months starts the weeks gets changed in dropdown. The work week starts from Sat-Sun. For Example : 10/29/2023 To 11/4/2023, Also I need to see previous 4 & coming 4 weeks in dropdown. Please help @WarrenBelz @FLMike
App On Start Code:
Set(
currentSunday,
DateAdd(
Today(),
-1 * (Weekday(Today(), StartOfWeek.Sunday) - 1),
TimeUnit.Days
)
);
Concurrent(
Set(currentUser, User()),
Set(
currentSunday,
DateAdd(
Today(),
-1 * (Weekday(
Today(),
StartOfWeek.Sunday
) - 1),
TimeUnit.Days
)
),
Set(
weeksList,
ForAll(
Sequence(
9,
Day(
DateAdd(
Today(),
-1 *(Weekday(
Today(),
StartOfWeek.Sunday
) -1)
)
)-28, // I need to change this Value every Month
7
),
Date(
Year(Today()),
Month(Today()),
Value
)
)
)
);
