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?