Skip to content
+1-888-319-3663

COMMUNITY FORUM

Filter CRM Data Source "Opportunity" by Year.

John Cogovan asked 5 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.
Thoughts?

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