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 ShahCommented Dec 21, 2015 at 4:23
-
Reference for date validation using JSLink : edinkapic.com/2007/10/add-javascript-date-validation-into.html– Dipen ShahCommented 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.– sansSpoonCommented Dec 21, 2015 at 23:20
-
I'll look more for the same and answer u shortly. .– Dipen ShahCommented Dec 22, 2015 at 3:23
Add a comment
|
2 Answers
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
answered Dec 21, 2015 at 9:12
-
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. Commented Dec 21, 2015 at 23:42
You can make it = [date1] > ([date2] - 10)
answered Dec 21, 2015 at 7:10
