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
sunil2018sunil2018 

Workflow rule - if then else formula error

Hi, I am writing a workflow formula that return and set a date on the base of below criteria.But its giving me syntax error.Any guidance would be appreciated.

Requirement:  1. If city = DELHI , then set date to (current Year,07,15) else set it  (current Year,08,20)
                           2. Add a year if current date is after  15 July when city = Delhi
                          3. Add is year if currnt date is after 20 August.

Workflow formula:
If(Text(City__c)= “DELHI”,DATE(YEAR(TODAY(),07,15), DATE(YEAR(TODAY(),08,15)),
DATE(YEAR(TODAY()+1,07,15),
DATE(YEAR(TODAY()+1,07,15),
If(YEAR(TODAY(),08,20)<TODAY(),
DATE(YEAR(TODAY()+1,08,20),
DATE(YEAR(TODAY()+1,08,20)))
 
SubratSubrat (Salesforce Developers) 
Hello Sunil ,

Please try with below validation rule :
  
IF(
    TEXT(City__c) = "DELHI",
    IF(
        MONTH(TODAY()) < 7 OR (MONTH(TODAY()) = 7 AND DAY(TODAY()) < 15),
        DATE(YEAR(TODAY()), 7, 15),
        DATE(YEAR(TODAY())+1, 7, 15)
    ),
    IF(
        MONTH(TODAY()) < 8 OR (MONTH(TODAY()) = 8 AND DAY(TODAY()) < 20),
        DATE(YEAR(TODAY()), 8, 20),
        DATE(YEAR(TODAY())+1, 8, 20)
    )
)

Hope it helps !
Thank you.