4 Replies Latest reply: Nov 10, 2015 8:04 AM by Jonathan Dienst RSS

    Difference between date

    Anna Perini

      Hi, i need to represent time how many tickets have been solved the last month, within x days (a variable called vDatSet) from support request and time to solve problem.

      I've tried to :

      if((date([Solution])-date([OpenTicket]))<=$(vDaySet),count(distinct ID_Ticket))

      but I dont' understand how set date on last month and how match set analysis and if condition.

      Help me pls.