3 Replies Latest reply: May 25, 2016 4:31 PM by Sunny Talwar RSS

    Script Logic

    Rajashmita Kar

      Hi Team,

       

       

      I am facing issue with one logic. I have two date field Start Date and End Date.

       

      I want if Start Date=End Date,then show Active and if StartDate<End Date, then show Expired.

       

      If(Date(StartDate,'YYYY-MM-DD'),'Active',if(Date(End Date,'YYYY-MM-DD'),'Expired') as Status

       

      But this is not working. Any idea how to resolve this?