Forum Discussion
Block List entry by calculated days
Hello all,
we have list for colleagues, which need to travel outside there homecountry. They have announce a travel at least 10 before the starting date.
In our list we have the travel starting date and the "entry created on" date. We want to block the entry if the two dates are less than 10 days away from each other.
Example:
Travel start date 24.01.2023, entry created on: 02.01.2023 = entry can be saved
Travel start date 24.01.2023, entry created on: 20.01.2023 = entry cant be saved and the employee must contact HR
Is this possible in a sharepoint list?
Regards
Erik
Hello ErikKohler
you can use a column validation to check the travel start date. Configure your column and add an validation:
In your entry it looks like this:
Kudos to ganeshsanap for more information:
Best, Dave
3 Replies
Hello ErikKohler
you can use a column validation to check the travel start date. Configure your column and add an validation:
In your entry it looks like this:
Kudos to ganeshsanap for more information:
Best, Dave
DaveMehr365 Thanks for the mention David. Happy to hear that my solution helped OP ErikKohler
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
- Thank you Dave, this helps me a lot.
Cheers,
Erik
