Exam Certified Platform App Builder topic 1 question 52 discussion

Actual exam question from Salesforce's Certified Platform App Builder

Question #: 52
Topic #: 1

[All Certified Platform App Builder Questions]

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?

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

Show Suggested Answer

Suggested Answer: C 🗳️

by larela4432 at Nov. 25, 2021, 2:14 p.m.

Comments

Submit Cancel

DonDemik

9 months, 3 weeks ago

C. DATE() is not correct because the DATE() function returns a Date value, given a year, month, and day.

upvoted 1 times

...

long_one

1 year, 3 months ago

C. Use the Formula: Today() - DateMarketingCommSent__c

upvoted 1 times

...

Ma21

1 year, 6 months ago

C: The TODAY() function returns the current day, month, and year as a Date data type. ... The NOW() function returns the Date/Time value of the current moment. It's useful when you are concerned with specific times of day as well as the date. https://help.salesforce.com/s/articleView?id=sf.formula_using_date_datetime.htm&type=5

upvoted 2 times

...

larela4432

1 year, 6 months ago

is C correct ?

upvoted 2 times

frn

8 months, 1 week ago

Yes, The NOW() function returns the Date/Time value of the current moment, and we are interested in days, not time (hours).

upvoted 1 times

...