1

I have a very simple validation script , which compares a date added to the created date and if there is 6months after then it will NOT show an error but if it is before 6months after the created date then it will complain.. It works once, but when you edit that column it just errors no matter what you enter : 

=IF(TAtestColumn>DATE(YEAR(Created),MONTH(Created)+6,DAY(Created)),TRUE)

So first time around if the date is 6 months in the future it works , but editing the list item afterwards the formula does not work

Any ideas ?

Improve this question
3
  • sorry I badly read the problem. so if you edit the item the formula value doesnt refresh?
    – Zdeněk Vinduška
    Commented Feb 21, 2019 at 13:05
  • sure if you edit the item the error appears evenrthough it shouldn't. so if you put in 6 months today on the new item, and then you edit the item and one day to it, so 23rd august - it errors even though the date is valid
    – Jason Hough
    Commented Feb 21, 2019 at 13:07
  • anyone has any ideas ?? Its driving me insane !! :)
    – Jason Hough
    Commented Feb 21, 2019 at 13:53

1 Answer 1

Reset to default
1

Make a calculated column of 'Created' and set that to Date only - and use that in the formula.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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