Thursday, February 21, 2013 5:39 AM
Need your help to solve this puzzle !!!
My business logic : Get all the leads which activities hasn't been looked into prior to last 3 months and one of the Lead date field is in next 3 months (see below image).
so if today is 21 Feb 2013, I want all the leads which activities haven't been touched prior to 21 Nov 2012.
When I constructed below simple Advanced Find, results were not correct as it includes Leads with activities which 'Last Updated' dates were after 21 Nov 2012.
Can someone please have a look into this and advise me accordingly. My understanding is when any activity record gets updated, "Last Update" fields gets updated with that time stamp which
one can query in Advance Find. Also, 'Last updated' field sits at "Activities" entity level rather than at individual activity like Phone call, Task,Email etc....so by theory it should work !!!!
Thanks for your time.
Thursday, February 21, 2013 8:10 AMAnswererTo query all activity types use "activity party" in the related entities. For the conditions, the condition you placed should work. If not, use two conditions with "and" operator: Last updated on or before some date AND Last updated on or after an early date such as 2000/01/01!
If the answer helped you, remember to mark it as answer.
- Marked As Answer by Payman BiukaghazadehEditor Sunday, May 12, 2013 4:55 AM
Thursday, February 21, 2013 9:42 PM
Thanks for your reply but that didn't work. I think activity party is the entity which holds to,cc,bcc values and doesn't have any Last Updated field.
- Edited by H.Desai Thursday, February 21, 2013 9:42 PM