Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us[email protected]
Menu
Salesforce Discussions
exam questions

Exam Certified Platform App Builder All Questions

View all questions & answers for the Certified Platform App Builder exam
Go to Exam

Exam Certified Platform App Builder topic 1 question 572 discussion

Actual exam question from Salesforce's Certified Platform App Builder
Question #: 572
Topic #: 1
[All Certified Platform App Builder Questions]

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?

  • A. DATEVALUE()
  • B. TODAY()
  • C. NOW()
  • D. DATETIMEVALUE()
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by Jason_R at Jan. 10, 2023, 4:38 a.m.

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
Jason_R
Highly Voted 1 year, 10 months ago
Selected Answer: B
B: See Question#52 The TODAY() function returns the current day, month, and year as a Date data type. The DATE() function returns a Date value, given a year, month, and day. 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 5 times
...
whoSaidThat
Most Recent 1 year ago
Selected Answer: D
D. Shouldn't it be D? The "elapsed" time determines the formula to use. "This formula converts the difference between two Date/Time values, datetime_1 and datetime_2, to days, hours, and minutes." So just for whole number of days then it'd be DateTimeValue() https://help.salesforce.com/s/articleView?id=sf.formula_examples_dates.htm&type=5
upvoted 1 times
...
whoSaidThat
1 year ago
D. Shouldn't it be D? The "elapsed" time determines the formula to use. "This formula converts the difference between two Date/Time values, datetime_1 and datetime_2, to days, hours, and minutes." So just for whole number of days then it'd be DateTimeValue() https://help.salesforce.com/s/articleView?id=sf.formula_examples_dates.htm&type=5
upvoted 1 times
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel