0 Replies Latest reply on Mar 18, 2013 11:37 PM by Praveen Kumar

    Calculated field for checking day of month

    Praveen Kumar

      Hi All,

       

      I have query regarding calculated field for the below scenario..

      I have data for crash count of different products for past few months.

      My query is tat I want to have a calculated field which checks for..

       

      if (i have data for current month) AND (whether my Today's date is >15)

      then (show data for current month)'

      else (show data for whatever latest month data available)

       

      Refer attached file for data

       

      Thanks

      Praveen