I need to limit the days allowed to select a shift, according to the selected days in an enum list of another table:
The enum list of the PROMO table contains:
MONDAY
TUESDAY
WEDNESDAY
โฆ Every day of the week.
According to the promotion, it is applied to certain days of the week.
I try to put a Valid if constraint in the field type date [Event Date]
WEEKDAY ([PROMO ID]. [Days])
And it gives me error โParameter 1 of function WEEKDAY is of the wronh typeโ
How should I do it? Is there any way that in addition to giving validation error message, block the selection in the calendar of the days not allowed?
Thank you so much
User | Count |
---|---|
56 | |
25 | |
13 | |
11 | |
6 |