5

I'm trying to use the 2013 built in date validation. I want to make sure the date entered into the GoLive Date is not more that 10 days in the past.

=[GoLive Date]>[GoLive Date]-10

How can I turn this into a true/false statement?

  • You can use JSLink on Date field on edit and New form. Apply JSlink , Fetch Date field , Check the value of field and throw user friendly message using JQuery. – Dipen Shah Dec 21 '15 at 4:23
  • Reference for date validation using JSLink : edinkapic.com/2007/10/add-javascript-date-validation-into.html – Dipen Shah Dec 21 '15 at 4:36
  • Hi Dipen, thanks for the tip, but I'm wanting to use the built in validation so it works with the data sheet view as well and new, edit forms. – sansSpoon Dec 21 '15 at 23:20
  • I'll look more for the same and answer u shortly. . – Dipen Shah Dec 22 '15 at 3:23
2

You can not reference other Columns in a Column validation,
so

=[Due Date]>[Created]-10

or

=[date1]>([date2]-10)

do not work (but can be used in the Form Validation: List Settings-> Validation Settings)

In a Column validation you can use the Today() function

date not older than 10 days in the past

=[Due Date]>Today()-10
  • I see now that doing my original calculation was comparing a value that hadn't been set. The today function will help me out here, thanks. – sansSpoon Dec 21 '15 at 23:42
0

You can make it = [date1] > ([date2] - 10)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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