on ‎2017 Jan 31 2:23 AM
Experts,
I have a list selection Edit type for a transaction property "WorkDate". I would like to restrict the dates in this calendar to LTEQ to system date. I have defined an include rule to restrict the values however, that doesn't seem to work as expected.
What am i doing wrong here? Any pointers will greatly help.
Help others by sharing your knowledge.
AnswerRequest clarification before answering.
I was still a bit confused so I pulled up the definitnions. The WorkDate field you are looking at that is defined as a list selection is not the field you see on the screen. If you check the Rules / Hyperlink / Special Value tab you will see its hidden rule is Always Hidden. Meaning it will never be shown. The field you see on the screen is WorkHrsDate which is defined as a date field. Date fields cannot be restricted during date selection. If you want to restrict a date entry you will need to use validation rules.
List selection does have an include rule which functions as you describe but the user interface for that is a list control not a date picker.
--Bill
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Bill. I have used validation rule for this as suggested.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Bill.
That's a good idea, i could use a validation rule. I would however like to know how to restrict values in the calendar. The WorkDate field shows date as date field but the edit type is list selection. I understand that there is an "Include" option for list selection that checks for each record in the object and if it matches a rule. Is this something i can use?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Are you sure you are looking at the right field? The workdate.jpg image shows the date as a date field not a list selection. I would recommend simply including a validation rule to ensure the date selected is not in the future. That way the user will be able to use the calendar picker to set the date.
If you want to use a list selection you will need to populate a collection with all dates less than the current date and the user will be able to click on a date value from the list.
--Bill
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 14 | |
| 9 | |
| 8 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.