locked
Date column validation in sharepoint 2010 lists (without designer) RRS feed

  • Question

  • Hi,

    I have a list with a date column which i want to validate against the current date at the item's creation time. When i insert a formula in the validation field, i always get errors. For example, i've tried this:

    [column name]>TODAY

    How can i get this to work? Sharepoint designer is disabled and i can't use it.

    Thanks and regards,

    Juan

    Tuesday, May 22, 2012 9:33 PM

Answers

  • Try using

    =[Column Name] > NOW()

    Edit: Or better yet...

    =[Column Name] > TODAY()


    Bob Guidinger

    • Edited by Bob Guidinger Tuesday, May 22, 2012 9:58 PM
    • Proposed as answer by Dmitry Kaloshin Wednesday, May 23, 2012 9:44 AM
    • Marked as answer by jdelga2 Thursday, May 24, 2012 11:10 AM
    Tuesday, May 22, 2012 9:55 PM

All replies

  • Try using

    =[Column Name] > NOW()

    Edit: Or better yet...

    =[Column Name] > TODAY()


    Bob Guidinger

    • Edited by Bob Guidinger Tuesday, May 22, 2012 9:58 PM
    • Proposed as answer by Dmitry Kaloshin Wednesday, May 23, 2012 9:44 AM
    • Marked as answer by jdelga2 Thursday, May 24, 2012 11:10 AM
    Tuesday, May 22, 2012 9:55 PM
  • Thanks Bob, it works beautifully.

    Regards,

    Juan

    Thursday, May 24, 2012 11:11 AM
  • Thank you. It helps me a lot.
    Tuesday, April 15, 2014 11:27 AM