SharePoint List Column Validation Help

Question

Hi all,

I'm trying to prevent users on a SharePoint list to enter values that are lesser than the item create date. Date resolved must be equal to date created or greater. I also need to be able to leave the value as blank when adding a new list item.

This is my current formula. It works until a user comes back to edit the item and when they enter a value that equals the same as the create date. It seems like equal to is being ignored?

=OR([Date Resolved]>=[Created],[Date Resolved]="")

Answer 1

Hello enomi5,

Thank you for posting to community forums.

As I understand from the description the users aren’t able to insert a value that equals the same as the create date. If my understanding isn’t matching your situation, please post back to us and point it.

This happens because when you create an item in SharePoint list with Created Date it creates a value that includes current date and time, but when you manually add a date to Date Resolved column the time value inserted as midnight (12:00 AM) that is considered by SharePoint list as a value earlier than created date. To solve this, you may try one of the suggestions below:

1. Select Date resolved column > Column settings > Edit > Turn on Include Time. After it you should require the users to enter the Date Resolved time that is equal or later then a Created Date time.

   2. Insert the following formula:
   
        **=OR([Date Resolved]>=INT(Created),[Date Resolved]="")**
   

Please let us know if this helped and feel free to post back if you need further assistance.

Best Regards,

Igor

Answer 2

Hi Igor, thank you for your assistance, this seems to have done the trick!

I greatly appreciate your help with it.

Answer 3

Hello enomi5,

We didn't receive your reply. Please let us know if you need further assistance.

Best Regards,

Igor