Appian Certified Analyst (ACD201) — Question 2

You're building an order management system.
You need to create a field that displays the total number of days it took to deliver each order, and show and sort by this data in a read-only grid. The data must be available in real-time.
Which function is the most appropriate for calculating this value?

Answer options

• A. calworkdays()
• B. a!subtractDateTime()
• C. a!customFieldDateDiff()

Correct answer: C

Explanation

The function a!customFieldDateDiff() is specifically designed to calculate the difference in days between two dates, which is ideal for determining delivery durations. In contrast, calworkdays() focuses on calculating workdays and may not provide the total days needed, while a!subtractDateTime() is not tailored for returning a simple day count, making them less suitable for this requirement.