Tracy van der Schyff

#Office365Challenge Still having fun with validations. Today’s post looks at date validations.

I cannot be more impressed by SharePoint’s validations on lists / columns. I have to admit I’ve always done these with either InfoPath or Nintex. So this has been quite an interesting journey learning what’s possible. However, I do struggle finding enough information on these. If you have formulas you’d like to share, please comment. I will test, blog and give you credit of course! Learning through sharing remember.

In the previous couple of blogs we’ve looked at forcing field completion based on another column’s input, forcing the completion of one of two columns, validation on minimum length of characters, telephone numbers, identity numbers and email addresses.

Today we’ll be looking at validations on dates:

Example 1:  Date should be greater than….

This is done as a list validation by going to the list settings (see previous blogs if you’re not sure how to do this). It cannot be a column validation as it references other columns in the formula.

=[Column1]>[Order Date]

=[Column1]>[Created]

You can also use the Created or Modified column as a greater than reference. Below you’ll see the Formula and the User Message:

Below you’ll see the User Message when dates do not validate.

Example 2:  Date should be greater than “date plus additional days”:

I tested another formula to only allow Delivery Dates, 14 days and more after the Order Date. Very simple and works like a charm.

=[Column1]>[Order Date]+14

Now that was real easy!

Related Posts:

• Day 285 – SharePoint List Validations – Force field completion (based on value of another field)
• Day 286 – SharePoint List Validations – Force completion of one of two columns
• Day 287 – SharePoint List Validations – Minimum Length of Characters
• Day 289 – SharePoint Column Validations on Telephone Numbers
• Day 290 – SharePoint Column Validations on ID Numbers
• Day 291 – SharePoint Column Validations on Email Addresses

Overview of my challenge: As an absolute lover of all things Microsoft, I’ve decided to undertake the challenge, of writing a blog every single day, for the next 365 days. Crazy, I know. And I’ll try my best, but if I cannot find something good to say about Office 365 and the Tools it includes for 365 days, I’m changing my profession. So let’s write this epic tale of “Around the Office in 365 Days”. My ode to Microsoft Office 365.
Keep in mind that these tips and tricks do not only apply to Office 365 – but where applicable, to the overall Microsoft Office Suite and SharePoint.