Skip to content


Filter CRM Data Source "Opportunity" by Year.

John Cogovan asked 6 years ago
I have a CRM 2016 data source (Opportunity Entity) that I need to filter a date/time field by current year.  I created a Global Variable to calculate the current year from the current date.  But in the data source I cannot figure out how to get the year from the date/time field to make the comparison.
Essentially I need to compare the Year of the Opportunity.Est.CloseDate to my global variable.  I can’t figure out how to change the Expression Column to give me that year.

If you would like to submit an answer or comment, please sign in to the eOne portal.