1 Reply Latest reply: Oct 15, 2012 9:57 AM by Miguel Angel Baeyens de Arce RSS

    Expression

    Hardik Gandhi

      Hi,

       

      My requirement here is:

      I have to claculate the difference between dates to measure oldest ticket still in open state:

       

      vDatetoday = today's date

       

      Status <> 'Closed' or Status <> 'Resolved'

       

      Field which holds the date value = [Incident Created Date]

       

      I am using the following expression but it is getting me the incorrect output.

      =Num($(vDateToday)-(MinString( {1<Status -={'Closed'} >} [Incident Created Date])),'#,##0')

       

      Thanks,

      H