+ 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!