QuestionQ291

Data Management

DreamHouse Realty needs house showings to be scheduled within the current year to avoid too many future showings accumulating.

How can it ensure that Showing Date is populated only with a date in the current year?

  • A Create a report that shows any Showing Dates not scheduled in the current year to be updated.
  • B Sync the users’ Showing Calendar to Salesforce and filter it to only look at this year.
  • C Add Help Text so the user knows to only add a Showing Date within the current year.
  • D Create a validation rule that ensures Showing Date contains a date within the current year.
Explanation

A Salesforce validation rule can enforce this requirement at save time by evaluating a formula such as YEAR(Showing_Date__c) <> YEAR(TODAY()) and displaying an error for dates outside the current year. Salesforce specifically documents this pattern for requiring a date field to be in the current year.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!