14 Replies Latest reply: Apr 11, 2016 7:19 PM by Marco Wedel RSS

    To compare a date field less than or grater than12 months

    sneha jha

      Hi,

       

      I am trying to calculate a field to identify the status of the activity.

      If the activity date is less than 12 months, then it is Active and if the activity date id greater than 12 months, then it is Inactive.

       

      For example -

      if(match([Type], 'Usable')=0 and [Activity Date]<365, 'Active', 'Inactive') as Active_Status


      Any clue, how to approach this ?


      Thanks for any help!