Hi, I have this policy that employees can only apply for Annual leave 3 days in advance, if it is less than 3 days, a label will be visible. This is the list that sets the condition for AnnualLeave with Days to apply in advance and when is the effective date. For example, the admin changes the Days to 5 and sets the Effective Date to 1/1/2023. So the policy will only be effective on 1/1/2023. If the employees apply before 1/1/2023, it will still be 3 days instead of 5. How to set it?
I tried using this formula but it doesn't work the way I want.
Set(checkCondition, LookUp('Leave Policy', Title="AnnualLeave"));
Set(checkCondition2, checkCondition.Days);
Set(checkCondition3, checkCondition.'Effective Date');
Set(
VarDateDiff,
RoundDown(
DateDiff(
Today(),
DataCardValue2.SelectedDate,
Days
) / 7,
0
) * 5 + Mod(
5 + Weekday(DataCardValue2.SelectedDate) - Weekday(Today()),
5
)
);
If(
Weekday(DataCardValue2.SelectedDate) = 7 || Weekday(DataCardValue2.SelectedDate) = 1,
Set(
VarDateDiff,
0
);
Set(
VarWeekEndError,
true
),
Set(
VarWeekEndError,
false
)
);
Set(
VarNegativeDateError,
If(
Today() > DataCardValue2.SelectedDate,
true,
false
)
);
Set(
VarAllowHoliday,
If(
VarDateDiff >= Value(checkCondition2) && checkCondition3 < Today(),
true,
false
)
);
Can anyone please help me?
Thank you.
