PL-400 · Question #71
Case Study 3 - Contoso Pharmaceuticals Background Contoso Pharmaceuticals manufactures and sells drugs to retail and wholesale pharmacies, hospitals, and research facilities. The company plans to…
The correct answer is D. DIFFINDAYS(CreatedOn, now()). The question asks for a formula to calculate how many days have elapsed since a record was created - a common requirement for SLA or aging dashboards in Dynamics 365. DIFFINDAYS(CreatedOn, Now()) returns the integer difference in days between the CreatedOn field and the current…
Question
Options
- AADDWEEKS(1, CreatedOn)
- BADDDAYS(10, CreateOn)
- CSUBTRACTDAYS(10, Now())
- DDIFFINDAYS(CreatedOn, now())
- EDIFFINWEEKS(now, 1)
How the community answered
(39 responses)- B5% (2)
- C10% (4)
- D82% (32)
- E3% (1)
Explanation
The question asks for a formula to calculate how many days have elapsed since a record was created - a common requirement for SLA or aging dashboards in Dynamics 365. DIFFINDAYS(CreatedOn, Now()) returns the integer difference in days between the CreatedOn field and the current date/time, which directly satisfies that need. Option A (ADDWEEKS) and B (ADDDAYS) add time to a date rather than computing a difference. Option C (SUBTRACTDAYS) subtracts days from Now(), not from CreatedOn. Option E (DIFFINWEEKS) uses incorrect syntax (missing parentheses and swaps the argument order). Option B also contains a typo ('CreateOn') which would cause a formula error.
Community Discussion
No community discussion yet for this question.