Announcements
Hi
I need to allow user to file a form in between Sunday to Saturday ( 07/03/2021 to 13/03/2021) only, I have update date column with "07/03/2021"
"14/03/2021"
"21/03/2021"
"28/03/2021"
so on......
Here I need to allow user to add details only when today() or Now() belongs to "07/03/2021" record
How do I get this
Thanks
I Got function 😉
If(( SPList.'Update Date ' >=Today()-Weekday(Today())+2 && SPList.'Update Date '<=Today()+(9-Weekday(Today()))),FormMode.Edit,FormMode.View)
Applied this at form DisplayMode event
Hi,
Thanks for your follow up post! I am glad that you were able to get this figured out. Hopefully this will prove useful for future communities users.
Regards,
Alex
-------
Community Support Team _ Alex RezacIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 421 Most Valuable Professional
11manish 153 Super User 2026 Season 2
MS.Ragavendar 116 Super User 2026 Season 2