Showing results for 
Search instead for 
Do you mean 

Filter by EditDate of opportunity.

New Member
Posts: 1
Country: United_Kingdom

Filter by EditDate of opportunity.

I'm currently writing an application that is testing the functionality of the Act! SDK. This application is being written in C# using the latest version of the Act Framework.


public OpportunityList GetLastModifiedOpportunities(ActFramework _act)
            CriteriaColumn column1 = _act.Lookups.GetCriteriaColumn(_act.Opportunities.GetOpportunityFieldDescriptor(StandardOpportunityField.EditDate));
            Criteria c1 = new Criteria(LogicalOperator.End, 0, 0, column1, OperatorEnum.Between, DateTime.Now.AddDays(-2), DateTime.Now);
            Criteria[] _criteria = { c1 };
            OpportunityLookup _oppLookup = _act.Lookups.LookupOpportunitiesReplace(_criteria);
            OpportunityList _oppList = _oppLookup.GetOpportunities(null);

            return _oppList;


The above method aims to gather a list of opportunity objects that were last modified within the last two days. I'm getting the error: 

criteria[0"] has an operator that is not valid for the specified column


The opportunity I am attempting to gather has the following value of the EditDate property: {31/08/2016 15:51:33}


My questions: 

Is it possible to filter by the EditDate of an opportunity?

How do you recommend I filter by the EditDate? 


Please let me know if you require any more information.