Unable to add a validation for our enterprise wiki pages' fields.. Error "List Data Validation Failed"

Question

I am working on an enterprise wiki site collection inside sharepoint 2013 farm. i have a custom date field named "ExpireDate", and i added a validation inside the Pages library's Validation settings, to force the "ExpireDate" to be in the future as follow:-

but when i tried to create a new wiki page i got this error, so now i am unable to create new wiki pages unless i remove the validation:-

so can anyone advice on what is the correct way to add field validations for our enterprise wiki pages? should i add the validation inside the page layout instead of using the Validation setting inside the pages library ?

Answer 1

I too can reproduce, but the only workaround is not to use OOB validation.

The only alternative I can think of is to use JavaScript. Put something like the following in a script editor web part on the new and edit forms:

<script type="text/javascript">
    function PreSaveAction() {
        var input = document.querySelector("input[id^='ExpireDate_']");
        if(input && input.value) {
            var expires = new Date(input.value);
            var today = new Date();
            today.setHours(0,0,0,0);
            if(!(expires > today)) {
                alert("Expires must be greater than today!");
            }
            return expires > today;
        }
        return true;
    }
</script>

Note that his will not validate if the field is empty, but you can configure it as a required field if you want to prevent empties.

Answer 2

I have done a test in my SharePoint enterprise wiki site collection and I can reproduce your issue. The only solution I could find is to remove the column validation.

For this issue, i would recommend you submit a feedback about this issue via the below link for your convenience, thanks.

https://sharepoint.uservoice.com/

It is a place for customers provide feedback about Microsoft SharePoint products. What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

Answer 3

This is to be expected and can not be avoided. You defined a rule and adding a new page will first create the page, then let you modify it. Now, creation violates the rule - hence the error.

You could try modifying the rule as follows: =OR([Created]=[Modified]; [ExpireDate]>Today())
This way you can create the page with an empty expire-date. I am afraid, though [Create]=[Modified] might be valid for a whole day...