calculating date difference

[#1]

hi

i am trying to calculate the  difference from the last modified date to present date..(today) i have attach an image of the data table that i am using.. as an output i need to take a count of all the incidents that is in the "pending " state more than 10 days.. can some one plz help me with this really really would appreciate the help

thank you in advance

[PradeepReddy]

try this..

Count(IF((today()-SMod_date)>10 and status='pending',IncidentID)

[MK_QSL]

Can you provide your sample data in excel file?

[#4]

In the backend create a new field if((Today() - SMod_Date)>10,1,0) AS NoOfDays

Use

SUM({$<status={'pending'}>}NoOfDays)

[SunilChauhan]

count( distinct if(Status='In Progress' and interval(today(),S_Mod_Date,'DD')>10,[Incident ID])

hope this helps

[jagannalla · Accepted solution]

=Count(If(Interval(Today()-S_Mod_Date,'D')>10 and Status='In Progress',IncidentID,Null()))