Unless you have a compelling reason not to, this can very easily handled by a validation rule that is simply Start_Date__c > End_Date__c – Chris Duncombe Sep 18, 2014 at 14:45
Full Answer
How do I ensure data quality in Salesforce?
Enforce the field as required in the field definition. See Require Field Input to Ensure Data Quality. Define validation rules to verify that the data a user enters in a record meets the standards you specify before the user can save the record. You can retrieve the error that’s returned by a validation rule using response.getError ().
How do I display a Validation rule error on a field?
Alternatively, use a base component built on Lightning Data Service to automatically display the validation rule error on a field. For example, you can define a validation rule that enforces an email address to contain @example.com.
What is the value of a custom date field?
Validates that the value of a custom date field is a Saturday or Sunday. Date must be a weekend day. Validates that a custom date field contains a date within the current month and year. Date must be in the current month.
What is the best way to work with Salesforce data?
When working with Salesforce data, we recommend that you use the lightning:recordForm, lightning:recordEditForm, lightning:recordViewForm, or force:recordData base components. They are built on Lightning Data Service, which ensures data consistency, while handling sharing rules and field-level security for you.
How do you validate a date field?
The date in the date field has to be after today's date and not in the past. It also has to be within 30 days from today's date. So if today is 15/01/2013, then the form can only accept any date within 30 days after the 15/02/2013, so the 14/04/2007 plus 30 days!
How do I validate a field in Salesforce?
Before creating validation rules, review the Validation Rule Considerations.From the management settings for the relevant object, go to Validation Rules.In the Validation Rules related list, click New. ... Enter the properties of your validation rule.To check your formula for errors, click Check Syntax.
How do you write a validation rule for a date?
For example, a date field might have a validation rule that disallows values in the past....Create a field validation ruleSelect the field that you want to validate.On the Fields tab, in the Field Validation group, click Validation, and then click Field Validation Rule.Use the Expression Builder to create the rule.
How do I compare dates in validation rules in Salesforce?
you can use the DATEVALUE(datetime field) function to extract the date part from the date/time field and then compare it with values like TODAY() - 1 or any specific date value ... you can use DATE(year, month, day) function to build a static date to compare..
What is data validation in Salesforce?
Validation rules in Salesforce verify the data a user enters in a record. The data should meet the standards specified by the organization. It can contain a formula or expression that evaluates the data in one or more fields & returns a value true or false.
Can we use field set in validation rule?
You can't write Validation Rules on Field Sets, but can Write Trigger and Validate in before insert.
How do I create a validation rule in Salesforce?
Creating a Validation RuleFrom Setup, go to Object Manager and click Account.In the left sidebar, click Validation Rules.Click New.Enter the following properties for your validation rule: ... Error Message: Account number must be 8 characters long.To check your formula for errors, click Check Syntax.More items...
How do I change the date format in Data Validation?
Set up the Data ValidationSelect cell C4, and on the Excel Ribbon, click the Data tab.Click Data Validation (click the upper section of the command)On the Settings tab of the data validation dialog box, from the Allow drop down, click Date.More items...
How do you ensure that only dates in a valid format can be entered in a particular cell?
How do you ensure that only dates, in a valid format, can be entered in a particular cell?Create a data validation rule for the cell that restricts users to only entering dates.Put a message in the cell that says users need to enter a valid date.Set up a data validation input message for the cell.
How do I compare two date fields in SOQL?
you can use daysbetween method to compare your date fields : date startDate = date. newInstance(2008, 1, 1); date dueDate = date.
How do I compare two datetime fields in Salesforce?
If you want to compare Date-Times as Dates, just use prevStartDat. Date() and currStartDate. Date() to convert them to Date values.
How do I compare dates in Salesforce?
You can use daysBetween if you want the number of days between two dates, but the six comparison operators (less than, greater than, less or equal, greater or equal, equals, and not equals), all operate the same way as they do on numbers. Show activity on this post. You just use <, <=, >, >= as you would with numbers.
Prevent Invalid Fields from Getting Submitted
In Creating a Form we implemented a basic form with built-in validation for required fields and specific types. Let’s customize the submission behavior such that the form displays errors on invalid fields. Customized behavior is useful if a user tries to submit an empty form and to identify errors in a field.
Example
The Aura Components Basics Trailhead module walks you through building a form for creating an expense record.
Field Validation Considerations
Client-side field validation provides an initial check for user data before submitting it to the server. Implement your own server-side validation to ensure that user data is saved in the expected format. Consider the following guidelines.
