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

    DateAdd Function Usage


      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.