function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Raja RSRaja RS 

Formulas And Validation Rules

HII All,
         Next visit should be greater than 30 days than Appointment Created Date:
       Next_visit__c<(Date value(Created Date )+30)
But its Showing An Error i.e, Error: Syntax error. Found 'Date'
 
Shunsuke Gimba (銀羽 俊介)Shunsuke Gimba (銀羽 俊介)
use addDays() method for adding 30 days.
Shunsuke Gimba (銀羽 俊介)Shunsuke Gimba (銀羽 俊介)
and collect field name from
created date to
createddate.
all field name doesnt contain spaces.
Devi ChandrikaDevi Chandrika (Salesforce Developers) 
Hi Raja,
There should be no space between Date value. 
Next_visit__c<(Datevalue(CreatedDate )+30)

Hope this helps you
Let me know if this helps you. Kindly mark it as solved so that it may help others in future.

Thanks and Regards


 
Raja RSRaja RS
Hiii Devi Chandrika ,
I had Using This formula
Next_visit__c<(Datevalue(CreatedDate)+30)
It Showing This Error:
 Error: Formula result is data type (Boolean), incompatible with expected data type (Date).

 
mr dhonimr dhoni
Hola everyone, A validation rule can contain a formula or expression that evaluates the data in one or more fields and returns a value of “True” or “False”. Validation rules also include an error message to display to the user when the rule returns a value of “True” due to an invalid value. best wishes by Cyberflix (https://cyberflixapk.fun/) Team 

This one of the best solution website salesforce provides the more information to get the info on: https://help.salesforce.com/apex/HTViewHelpDoc?id=fields_about_field_validation.htm for updated validation rules.
Deepak VaishnavDeepak Vaishnav
This answer fixed the issue of mine 
Regards Deepak Vaishnav BD of Sportzpari.com