Hi all,

I built a report with report type Opportunities and would like to add a filter saying Close Date <= 31.12.CURRENT YEAR. For this year it would be <= 31.12.2019.

I found in the Salesforce Documentation the following statement:

For example, instead of filtering on Close Date greater than Jan 1, 2017, filter using a relative date: Close Date equals this year.

Attached the link to the documentation:

https://help.salesforce.com/articleView?id=filter_dates_relative.htm&type=5

If I use Close Date <= THIS YEAR I am wondering if this is the correct solution, as THIS YEAR means "Starts at 12:00:00 AM on January 1 of the current year and continues through the end of December 31 of the current year". I just want to tell Salesforce, I want all records with Closed Date <= LAST DAY OF THE CURRENT YEAR without using any formulas.

If using formulas what would be a practical approach here?.

@Salesforce Administrators & Developers @* Salesforce Administrators * @Architect Trailblazers @Reports & Dashboards @Who owes me a beer?!? @Admin Group, San Diego, US @Admin Addicts @Salesforce Certified Professionals @Admin Group, London, UK @Developer Group, London, UK @Admin Group, Orange County, US @Admin Group, Salt Lake City, US @Developer Group, Austin, US @* Salesforce Developers * @Developer Group, Vancouver, CA @Admin Group, Fremont, US @User Group, Amsterdam, NL (Deleted Group) @Developer Group, Fort Lauderdale, US @Boston Developer Group @EMEA Architects Club @Developer Group, Manchester, US