1 Reply Latest reply on Dec 20, 2016 12:51 PM by Ashlyn Opgrandd

    DateAdd Function Usage

    garima.vatsa.0

      Hi People,

       

      I have two calculations in my dashboard first is:-

       

      low = (countd(category)+STR(1))

       

      Second is:-

       

      Low Date =  DATEADD('day',[Order Date],(IIF([Low]<=12,[Low],12)))

       

      My first calculation works fine but my second calculation gives me error saying "Dateadd is being called with (string,date,integer)". Can anyone please help me on this. I want my lowdate to be incremented by value returned by IIF condition.

       

      Thanks

      Garima