Validate Start Time With Current Date In Sharepoint?

1
votes

I have a column called Start Time (it's a SharePoint Default Calendar Column). I need to validate if the Start Time is less than today or not? Without using javascript? Is this possible?

I have tried this:

  1. Created a column called Today type as Date and Time.
  2. Default value is current date.

  3. Then compared the Start Time and Today in validation settings like the following: 

    =[Start Time] < [Today]

it seems not working. help please?

2
validationsharepointdatetimesharepoint-2010calendar

2 Answers

4
votes

Try this code instead of yours 

=[Start Time]<NOW()
1
votes

I use this to validate that Start Date must be less than or equal to Today: 

=[Start Date]<=Today()

...and it works for me.