Hi, is it possible to make a restriction on the day of the week selected in a date field?
Example: all our transfers start on a Sunday. Is it possible to constrain the effective date to only allow Sunday dates to be selected?
One thing is some help text for the end-user. This will give a little blue icon they can hover over:effective date mouse over text is "PleaseSelectASundayDateOnly"For validate logic, try this perhaps:effective date constraint (effective date week day = 1) "DayOfWeekMustBeSunday"
The "week day" TypeOperator on a date will return a week day number (1-7). 1 is Sunday.
Another more complex solution is to only present a user field that is the list of Sunday dates as the effective date field a user sees. Then use "when value changed" to update the real "effective date" field to equal your user field. E.g.UserEffectiveDateKeyfield label is "EffectiveDate" when value changed effective date = UserEffectiveDatevisible when (false) effective dateHere you need to create records for all of the Sunday dates for a year though.
I'm going to create a post to ask the community more generally about other requirements and rules they have around controlling effective date selection. I'm sure Infor can look into more ways to make this easier and user-friendly for the users and HR back-office.
Wonderful! I will try this out.
