function readOnly(count){ }
Don't have an account?
Search for an answer or ask a question of the zone or Customer Support.
You need to sign in to do that
Sign in to start searching questions
Signup for a Developer Edition
Sign in to start a discussion
I need to prevent users from entering start dates that are less than the current month and year.
Thank you in advance
Simply add the ISNEW() function to it
AND(IF(OR(MONTH(CloseDate)<>MONTH(today()),YEAR(CloseDate)<>YEAR(today())),true,false),isnew())
In the strictest sense, this would work
IF(OR(MONTH(CloseDate)<>MONTH(today()),YEAR(CloseDate)<>YEAR(today())),true,false)
That works! And then to prevent users from editing the start date on an existing record, I did an ischanged on the date.
Thank you.
Simply add the ISNEW() function to it
AND(IF(OR(MONTH(CloseDate)<>MONTH(today()),YEAR(CloseDate)<>YEAR(today())),true,false),isnew())
All Answers
In the strictest sense, this would work
IF(OR(MONTH(CloseDate)<>MONTH(today()),YEAR(CloseDate)<>YEAR(today())),true,false)
Simply add the ISNEW() function to it
AND(IF(OR(MONTH(CloseDate)<>MONTH(today()),YEAR(CloseDate)<>YEAR(today())),true,false),isnew())
That works! And then to prevent users from editing the start date on an existing record, I did an ischanged on the date.
Thank you.