How to get the current year records from custom object where year is in a text field?

String dateOfToday = String.valueOf(Date.today().year());

Then your SOQL would include this in the where clause.

Note: Use the API name of your field

WHERE Sales_Year__c = :dateOfToday

(706)

Written by 

I am Sakthivel Madesh, a certified Salesforce Developer & Administrator working on Salesforce Technology since 2011. I am currently working in Techforce Services as Sr. Salesforce Developer. I have worked on multiple technologies Like PHP, Java, Salesforce, I am very passionate about Salesforce and to earn 13x Salesforce Certification. I love Trailhead for learning Salesforce Skill and Become a Trailhead Ranger too. I Love to Learn & Share my Salesforce knowledge to Salesforce Learners/Beginner using My Blog and Salesforce Community.

Leave a Reply