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

[MK_QSL]

You can create a flag in your script and use SUM(Flag)

IF(Status = 'Pending' and Interval(Today() - [Modified Date],'DD') >= 10, 1, 0) as Flag

[#3]

=if((today()-LastModifiedDate)>10 and (status = 'pending'),1,0)

[#4]

hi sneha

my today date n the last modified date formats r different so will this function work??

[#5]

hi manish

my today date n the last modified date formats r different so will this function work??

[#6]

convert both dates to same format for comparision purpose

=if((timestamp(today())-timestamp(LastModifiedDate)>10  and status = pending),1,0)

[jagannalla]

Try to convert your date column into date format and then use the expression.

[#8]

i converted my date column in to the right format but i am still unable to get a count 😕

[jagannalla]

Can you attach sample file.

[#10]

i am sorry Jagan i can not attach the file due to official reasons but i have attached an image of the data table in that i have converted my last modified date in to the proper format... i need to take a count of all the incidents which is in the in progress state more than 10 days..

=if((today()-SMod_date)>10

this function might be right but how can i take a count ?? 😕