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
Craig HansenCraig Hansen 

Syntax error. Missing ')'

Trying to build a validation rule so sales rep cannot mark the Closed Date on Opp in the past.  Must be today or future

My error Condition formula 
AND (CloseDate < TODAY (), ISPICKVAL(StageName, "Closed Won), $User.ProfileId = "00ei0000001FT2k")

I check syntex and receive Error: Syntax error. Missing ')'    What am I overlooking?
Best Answer chosen by Craig Hansen
Deepak GulianDeepak Gulian
You missed the double quote on the right of text "Closed Won"
AND (CloseDate < TODAY (), ISPICKVAL(StageName, "Closed Won"), $User.ProfileId = "00ei0000001FT2k")

All Answers

Deepak GulianDeepak Gulian
You missed the double quote on the right of text "Closed Won"
AND (CloseDate < TODAY (), ISPICKVAL(StageName, "Closed Won"), $User.ProfileId = "00ei0000001FT2k")
This was selected as the best answer
Craig HansenCraig Hansen
That did it!  Ugh..details... Thanks!