Forum Discussion
Compare the Text Date Time Value
Hi,
Kindly assist how can I put column validation for my Start and End Date in My Sharepoint list for Single Text field. Below is my formula in PowerApps:
If(DateTimeValue(StartDate.Text)>=DateTimeValue(EndDate.Text))
Thanks
geekcode0315 What exactly you want to do with the validation? Do you want to do it via Power Apps only or are you fine with SharePoint default suggestions as well?
You can directly apply the validation in SharePoint list validation settings as well without customizing the list form using Power Apps.
Use list validation formula like:
=DATEVALUE([End Date])>=DATEVALUE([Start Date])
Note:
- Sometimes comma( , ) does not work in formula (it is based on language or regional settings on your site). So in that case use semicolon( ; ) instead of comma( , ).
- Use correct display name of your SharePoint columns in above formula.
- Wrap column names inside [] if your column name has space in it. For example: [My Column Name].
Steps to add list validation settings at: How to have validation for SharePoint list columns?
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.
- geekcode0315Copper Contributor
ganeshsanap Hi ganesh, Sorry for my late response but I tried the formula above prompted error as below. Thanks
I think you are adding this formula in column validation - However, you will have to use this formula in list validation settings.
So, try adding the formula in list validation settings by following the steps given in link I shared in above response.
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.