Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

i have a pronlem on validation on edit mode of list items. my a simple list have a column named : "StartTime" with date & time type. and i add this validate rule : "=[Created]<[StartTime]" it is work on newform.aspx but on editform.aspx this not work and user can edit time to befor creation item! is this a bug on share point? if yes or no is any way to control that "starttime" can not give a value smaller than "Created".

share|improve this question
add comment

2 Answers 2

up vote 0 down vote accepted

I suggest two ways to fix that problem:

  1. Add the calculated field in addition with "Created" field:

    • Create calculated field (for ex "CreatedDate") with Formula="=[Created]".
    • Change StartTime field's validation formula to "=[CreatedDate]<[StartTime]".
  2. Or use TODAY() instead [Created] (If it will be suitable for you)

share|improve this answer
    
Not sure this is what he is looking for - he meant the VALIDATION Rules prior to updating items, not calculated columns! –  C. Marius - MVP Apr 22 '13 at 12:50
    
waht is "field instead of OOTB" ? –  Mo.Nasseri Apr 24 '13 at 7:17
    
OOTB means Out of the box feature. I meant you need to add new calculated field. Not "instead", sorry, in addition with "Created". I updated my answer. –  Andrew Apr 24 '13 at 7:33
    
yeeeeeesss it's work.Really thank you dear @Andrew :) –  Mo.Nasseri Sep 10 '13 at 13:26
add comment

I asume you are trying to validate this at the column level? If so, this would not work as you are not allowed to use other fields. But what you could do is to create a validation formula at the List level and use the same formula, but without the EQUAL, basically in the Formula text area simply type [StartTime]>[Created] and then your message in case is wrong.

However, to my knowledge, validation using CREATED occurs only on NEW, but not on EDIT - so you might be out of luck. Using the MODIFIED could work, but not sure this would match your required logic.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.