Salesforce Certified Platform App Builder — Question 302

The Director of Marketing at Northern Trail Outfitters wants the app builder to create a formula field that tracks how many days have elapsed since a contact was sent a marketing communication. The director is only interested in whole units.

Which function should be used to return a date for calculating the difference?

Answer options

• A. DATEVALUE()
• B. TODAY()
• C. NOW()
• D. DATETIMEVALUE()

Correct answer: B

Explanation

The function TODAY() is ideal for returning the current date without the time component, which is necessary for calculating whole days since the last marketing communication. DATEVALUE() and DATETIMEVALUE() are used for converting text to dates, and NOW() provides the current date and time, which includes unnecessary detail for this specific requirement.