Forum Discussion

geekcode0315's avatar
geekcode0315
Copper Contributor
Mar 03, 2024

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

    1. 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( , ).
    2. Use correct display name of your SharePoint columns in above formula.
    3. 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.

    • geekcode0315's avatar
      geekcode0315
      Copper Contributor

      ganeshsanap Hi ganesh, Sorry for my late response but I tried the formula above prompted error as below. Thanks

       

      • ganeshsanap's avatar
        ganeshsanap
        MVP

        geekcode0315 

         

        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.

Resources