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?

4
  • 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, 2015 at 4:23
  • Reference for date validation using JSLink : edinkapic.com/2007/10/add-javascript-date-validation-into.html
    – Dipen Shah
    Dec 21, 2015 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, 2015 at 23:20
  • I'll look more for the same and answer u shortly. .
    – Dipen Shah
    Dec 22, 2015 at 3:23

2 Answers 2

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
1
  • 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, 2015 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 and acknowledge you have read our privacy policy.

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