Report on Task not updated in 2 days

[KaMmILa__]

How to query on task which are not updated in 2 days ?

I tried on the mentioned table and condition is 

Updated relative after 2 days ago ,  still its giving the wrong information , 

can some one help me with that condition ?

[Ankur Bawiskar · Accepted solution]

Hi,

you can use this

Updated [Relative] 2 Days Ago

Regards
Ankur

[Harsh Vardhan]

have you tried below condition

Updated | relative | on or before | 2 days ago

[Ian Mildon]

What is not helping your query is that you are not specifying who is updating/not updating the Task.

If you spend a little time looking at a list view of some records, you will see that there are a lot of "system" updates for things like SLA's and other "system" stuff. So if you are just querying for records with no updates for two straight days, you are likely not going to get good results.

Try using something similar to this:

if(sys_updated_bySAMEAScaller_id.user_name) {
		//do something
	}

This is something I used to check if the Incident "caller" was the last person to update the Incident record.

And after I posted this I see that you are needing this in a report format. This throws another issue in that the "sys_updated_by" is limited on what it can be compared to; as in only "created_by".