Salesforce Certified Platform App Builder — Question 168

The Director of Marketing has asked 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.
What function should be used to return today's date for calculating the difference?

Answer options

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

Correct answer: C

Explanation

The correct answer is C. TODAY() returns the current date without including the time, which is what is needed to calculate whole days since the last marketing communication. Options A (DATE()) and D (DATEVALUE()) do not provide the current date directly, while B (NOW()) includes the time component, which is unnecessary for counting whole days.