Filter by EditDate of opportunity.

Craig Close · ‎09-01-2016

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.